Re: Using the AS key word in SQL Queries

>On Tue, Jul 02, 2002 at 11:08:13AM +0530, Sachin Keshavan wrote: >> >> I am trying to execute the Query >> SELECT MAX(RECORDNO) AS MAXREC FROM BOOKS; >> >> while($row = mysql_fetch_array($sql_result)) >> { >> $bookID = $row['MAXREC']; >> } >> >> This query fails. Am I doing any thing wrong here. Warning: In addition to any SQL error you may have, you almost-for-sure are making a newbie logical flaw in your programming. Let me ask you this question: What if *TWO* (2) people add new books at *EXACTLY* the same time? Do you *STILL* want the MAX(RECORDNO) ? Or am I gonna get the other guy's book, since his went in a micro-second after mine did? :-) You may want to look into this function: http://www.php.net/manual/en/function.mysql-insert-id.php I could, of course, be wrong, and you're not making the same mistake a million others have made before... :-) -- Like Music? http://l-i-e.com/artists.htm