Re: [PHP] MySQL selecting the maximum value from a column

2002-02-05 Thread Lars Torben Wilson
On Tue, 2002-02-05 at 15:12, Melanie Gann wrote: > Thank you all you listeners out there. I'll try to be respectful of your > time and patience, and apoligize in advance for my "greeness" - I am 2 > weeks into PHP/MySQL. > > I am trying to select the higest value from the column Thought_Num below

RE: [PHP] MySQL selecting the maximum value from a column

2002-02-05 Thread Martin Towell
what happens if you do this? $result = mysql_query("SELECT MAX(Thought_Num) as Thought_Num FROM quotes",$db); I'm thinking that the column name in your original query is being called "MAX(Thought_Num)" and not "Thought_Num". Martin -Original Message- From: Melanie Gann [mailto:[EMAIL P