no results
Posted: Fri Dec 13, 2002 8:50 am
Code: Select all
$queryA = "SELECT MAX(id) FROM journal";
$resultA = mysql_query($queryA) or die("Couldnt retrieve journal.");
$day_max = mysql_fetch_array($resultA);
$queryB = "SELECT date,day,entry FROM journal WHERE id='$day_maxї0]'";
$resultB = mysql_query($queryB) or die("Couldnt retrieve journal.");
$latest_entry = mysql_fetch_array($resultB);
$latest = $latest_entryї0];
$latest .= "~Day ".$latest_entryї1];
echo $latest;