not sure why this wont work?

[mattm1712]

$last = mysql_query("SELECT MAX('id') FROM comments WHERE submittedby='$username'");

 

 

can any1 help me?

[.josh]

be more specific than "it doesn't work".  post errors, what it is supposed to be doing, what it is (not) doing.

[mattm1712]

im trying to select the latest post posted by eaach member on my site,

 

the database is layed out in the umage attached,

 

 

 

 

[attachment deleted by admin]

[mattm1712]

this is the full code i have

 

$username = $_SESSION['user'];

$last = mysql_query("SELECT MAX(id) FROM comments WHERE submittedby='$username'");

$lastdate = mysql_fetch_assoc($last);

$ld= $lastdate['date'];

echo $ld;

[.josh]

well if that's your full code, then your first problem is that you aren't connecting to your database. Your 2nd problem is you don't have session_start.

[MMDE]

As Crayon says, you need to connect to mysql first and select database.

 

From what I can see of this script, it seems like you want the "last"/"highest" id number... may I ask why? because if it is so that you are going to insert a new user after this with 1 id higher than the current max, then I rather suggest you just set the column in mysql to auto increase and primary.