Getting largest Value from table

Dark_Storm

Ok, I have a forum with many smaller forums inside it. It lists all the different forums with the number of posts, replies, and the last post.
Then you click on the link to open that particular forum. But everytime i delete a post, I have change the last post. I want to do it by getting the biggest 'id' of a particular post.
So we have posts 0,1,2,3,4,5, but I don't know how many posts there are at any given time, so I just want PHP to dynamically select the biggest value from 'id'. 'id' just stores numbers, the id of a post.
How do i select the biggest number out of a field in the database?

statrat

select max(id) from table

mogster

If the field is an int, just use
SELECT from field ORDER by myid DESC
if you want decreasing numbers (biggest number at the top), or:
SELECT from field ORDER by myid
if you want them to increase.

To just select the biggest value:
SELECT * from field ORDER by myid DESC LIMIT 1

knutm

Dark_Storm

thanks man, that has been bugging me for so damn long. I got one more question real quick that i forgot earlier. How do i run just a select query and print out the results in HTML using just a variable? Becuase if I do like

$query = mysql_query("SELECT this FROM that WHERE id='1'");
print ("$query");

that doesn't work...I don't want to have to use up all the lines going thru a

while ($row = mysql_fetch_array($result)) {  $info = $row[this];  }

cuz that just takes too long to write...lol i am lazy can u tell?

LordShryku

print $query is just going to print your statement. Your $query statement is nothing more than a string. You have to have a cursor to actually perform the query staement, and a fetch to process the records it does pull. Lazy or not, no way around it. sorry :rolleyes: