Hi all,
I'm running the following query:

PHP Code:

$sql3 = "SELECT page_id FROM $table";
$result3 = mysql_query($sql3) or die ("Couldn't perform query -".mysql_error());
$row = mysql_fetch_array($result3);
$num = mysql_num_rows($result3);
// Get the last number in the array of page_id's
$last = $row[$num];
$new = $last+1; 


... in order to generate a number for use later in the script. I was expecting "$row[$num]" to be the number stored in the last row of "page_id", but it's not: the only value I can get for $new is 1.

Please note that I am attempting to get the value contained in the last row of "page_id", not the row number itself!

What am I doing wrong?
Thanks in advance!

PHP Code:

$row = mysql_fetch_array($result3); 


You'll only get an array of the first row if your do that. To get the last row, do:

PHP Code:

//the sql query
$sql3 = "SELECT page_id FROM $table";

//preform the query
$result3 = mysql_query($sql3) or die ("Couldn't perform query -".mysql_error());

//amount of rows in query
$num = mysql_num_rows($result3);

//go to last row in query
mysql_data_seek($result3, $num-1);

//fetch last row in query
$lastrow = mysql_fetch_array($result3);

//print last page_id
echo $lastrow['page_id']; 


If you only need one row, then you should not query the database for the entire table, it is very inefficient. In this case it looks as though you could just order by page_id in descending order, and the first row will be the row you are looking for:

$sql3 = "SELECT page_id FROM $table ORDER BY page_id DESC LIMIT 1";
$result3 = mysql_query($sql3) or die ("Couldn't perform query -".mysql_error()); 
$row = mysql_fetch_array($result3);

Provided that page_id is an "auto_increment" field. You won't have the right effect otherwise.

thank you guys, both solid ideas that work.