Embarassing question

Anon

This is really embarassing that I can't figure this out but I put in the below query and all I want is my max id. I know there query is right but I can't get it to put it out (appears as empty).

I typed the query into mysql and I get the correct number so I don't think it's the query that's wrong.
All my comments are in BOLD //////////

Thanks,
KABOOM!

// Grab all the information about the student
print "USER: $user ";
$getmaxrid = mysql_query("SELECT max(rid) FROM reportcard WHERE username='$user'");
if(!$getmaxrid)
die(mysql_error());
$maxrid = mysql_fetch_object($getmaxrid);

/////////// NEXT LINE IS BLANK EMPTY //////
print "MAXID: $maxrid->rid ";

// THIS LINE TELLS ME I HAVE THE CORRECT NUM
$numuser = mysql_num_rows($getmaxrid);
if($numuser <= 0)
die("No Report card at this time");
if($numuser > 1)
die("ERROR: An error occurred in retrieving your report card ");

takuma

Try changing
print "MAXID: $maxrid->rid ";
to
prin "MAXID: ".$maxrid->rid." ";

Hope that helps.

Regards,

Takuma

Anon

No go on that. Didn't work.

Anon

your mysql query should be ("SELECT MAX(rid) AS rid FROM reportcard WHERE $username='$user'")

try something like this:

<?
$query = ("PUT QUERY HERE");
$maxid = mysql_query($query)or die("Error in Query: $query);
while($row = mysql_fetch_object($maxid) {
echo $row->rid;
}

mysql_free_result($result);
?>

if it still is displaying nothing try var_dumping $row, to see if it has found anything at all.

hope this helps