problem with max() function in php to mysql

[makoy]

Hello everyone I have a piece of code below that display a weird problem. It displays "ndefined index variable newsid" when I run the script. I have a feeling that the max(newsid) function is the problem but I'm not sure about it so I really need your help guys. btw guys when I changed the $msq = "select max(newsid) from news" to "select newsid from news", it worked but it displayed all the news id. What I want in the script is to only get the highest id in the database. Can you guys help me please. Thank you very much. 🙂

<?php
include("connecttomysql.php");

$msq = "select max(newsid) from news";
$result = mysql_query($msq);

while($row=mysql_fetch_array($result);
{
 $id = $row["newsid"];
 echo $id;
}

mysql_close();
?>

[Deep_Dhyani2]

please check :

	- newsid should be Int type
	- $msq="select max('newsid') from news";

[alex2046]

select newsid from BOOKS order by newsid desc
$row=mysql_fetch_array($result);

$id = $row["newsid"];
echo $id;

[darkerstar]

select max(newsid) from news

Basically the problem is, the name of the return result is not "newsid". When you use functions like max, total, count the returned result will not have the same field names you have in your database table. To fix it you need to define a name for it. like max(newsid) as xxx

try change it to

"select max(newsid) as maxid from news"

$id = $row["maxid"];

William