PHP ==> MYSQL anybody knows whats wrong with this php code?

Question

I got this code that has to get the last news from the database and print it but the output is weird an instead of printing the last new it prints: "Resource id #4"
anybody knows whats wrong with this code?

mysql_connect ('localhost' , 'root' , '');
mysql_select_db ('db2');
$data = mysql_query ("SELECT * FROM news");
$rowsnum = mysql_num_rows ($data);
$news1 = mysql_query ("SELECT new FROM news WHERE id = '$rowsnum'");
echo $news1;

I have the databass and when i get the number of the rows its exactly the same as number of the rows in database so theres nothing wrong with connecting to the database and getting the information

thx M. raja it fixed my problem but i still dont understand wat was wrong with my code lol.
doesnt matter it works now :)

Answer 1

everything is correct, but "rowsnum'" not an id in the table. Instead of this you can use maxid.

mysql_connect ('localhost' , 'root' , '');
mysql_select_db ('db2');
$news1 = mysql_query ("SELECT new FROM news WHERE id =(select max(id) from news)";
$row=mysql_fetch_array($news1);
$newslast=$row['new'];
echo $newslast;

Please try this code

Answer 2

An improvment on that last bit...

...
$news = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 1");
echo mysql_result($news,0);

This assumes id is an auto_increment value.

This method is more efficient because there is no WHERE clause so MySQL doesn't have to do any comparisons. It just sorts them based on id (which should be the primary key or at least indexed), grabs the latest one (LIMIT 1) and then instead of mysql_fetch_array(), you just use mysql_result with 0 as the row index (since we only pulled one value).

Answer 3

Did you setup the database??

what is the program ??