limit or last

[OwenTheSamoan]

I'm using php with mysql I have a field that contains six entries, how would I create a select statement that would only give me the last entry that was inserted into a field? I know if I use limit 0, 5 this would give me the first five entries only. How would I only get the very last entry?

[devinemke]

is there an auto numbering integer primary key field or a datetime field? if so use the MAX() function.

[OwenTheSamoan]

but wouldn't max() just give me the highest value from the group? I have an id field that can give me the order in which the values were inserted, I just need to be able to pull out the last value from each group inserted.

[OwenTheSamoan]

I see where you were going with max(). I'm trying something like this, but it will not give me the last value inserted into the database for each username.

$result = mysql_query("select username, paid, max(AM2_id) from AM2 group by username ") or die (mysql_error());
while ($row = mysql_fetch_array($result))