Can't get my head around - help.
I have "master" the concept of PHP within html but I can't get my head around SQL queries...
I'm trying to do something pretty simple. I have a table which contain some data (1 line at the moment). the 1st column contain Article_ID. What I want is the highest number of the column.
This is the Query I'm sending:
$query = "SELECT MAX(Article_ID) FROM Table_Article";
$result = mysql_query($query) or die ("Problem encounter ".mysql_error());
$row=mysql_fetch_array($result,MYSQL_NUM);
echo $row['Article_ID'];
I'm officialy not getting this at all since I'm not getting any value.
Can someone correct my code and perhaps inlight me a tiny bit on what I'm thinking wrong?
Thanks.
|