time and $password

[smrpgx]

How do I make it so that every hour, variable $password will change into a random 6-digit number?

[.josh]

run this script every hour with a cron job.

[code]
<?php

$newpassword = rand(100000,999999);

$conn = @mysql_connect('host','username','pw') or die(mysql_error());
$db = @mysql_select_db('database',$conn) or die(mysql_error());

$sql = "update tablename set password = '$newpassword' ";
$query = mysql_query($sql, $conn) or die(mysql_error());

mysql_close($conn);

?>
[/code]