[PHP] Using the AS key word in SQL Queries

[Sachin Keshavan]

Hello all,

I am trying to execute the Query
SELECT MAX(RECORDNO) AS MAXREC FROM BOOKS;

I am trying to access the value like this
while($row = mysql_fetch_array($sql_result))
{
         $bookID = $row['MAXREC'];
}

This query fails. Am I doing any thing wrong here. 

Thanks,
Sachin.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php