Create("jfsjr"); echo("
"); echo("
"); $sql->Query("Select count(*) from hooks"); $sql->Fetch(0); $cnt = $sql->data[0]; //1 is the first entry in the database - not 0 $id = rand(1,$cnt); //echo("count = $cnt
"); //echo("id = $id
"); $sql->Query("Select * from hooks where id = $id"); $sql->Fetch(0); $month = $sql->data[1]; $day = $sql->data[2]; $year = $sql->data[3]; $reading = $sql->data[4]; echo("


"); echo("






"); echo(" "); echo("
"); echo("$reading "); echo("
"); echo("
"); echo("

"); /* $sql->Query("SELECT DAY(CAST(NOW() AS DATE))"); $sql->Fetch(0); $datt = $sql->data[0]; echo("$datt"); echo("
"); echo("
"); */ ?>