Queries for Numbers

[Deposeni]

How would I return the highest number from a mysql_query? Like, the latest post... = the highest ID, or the most recent time() post.

[HalfaBee]

SELECT * from table ORDER BY posttime DESC LIMIT 1

This will return the most recent post.

HalfaBee

[Deposeni]

THANK YOU LORD! I worked 10 hours on my forum, and 3 hours on this ONE BUG! Til I thought "Hey, instead of matching the title, why not match the most recent post and do it that way?" - simple answer to a simple problem... Thanks a bunch

Also: How would I align something to the top of a <td> in a table?

[Deposeni]

Okay now it atleast sees it... But it won't update the row... Heres the query

mysql_query("UPDATE fforums WHERE id='".$_POST['id']."' SET posts=posts+1, topics=topics+1, lastpost='$posterid', lastpostname='$postedid'");
print "Your topic has been created.";
print "<meta http-equiv=\"refresh\" content=\"1;URL=viewforum.php?id=".$_POST['id']."\">";

It won't update posts, toics, lastpost, or lastpostname....

[HalfaBee]

Your syntax is wrong

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]

sets before the where

HalfaBee

[Deposeni]

Fixed... thanks