[SOLVED] LIMIT tag

[Zoud]

I have a little question. Were would I enter the LIMIT 0 , 5 tag on the coding below?

<?php
mysql_select_db("database", $con);
$result = mysql_query("SELECT * FROM news ORDER BY id DESC");

while($row = mysql_fetch_array($result)){
?>

 

I've tried the following:

SELECT * FROM news LIMIT 0 , 5 ORDER BY id DESC

SELECT * FROM news ORDER BY id LIMIT 0 , 5 DESC

SELECT * FROM news ORDER BY id DESC LIMIT 0 , 5

 

I need it so it will only show the last 5 that were inserted, but I tested each one and they'll eather show all or none.

[per1os]

$result = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 0,5") OR DIE(mysql_error());

 

That is the correct way, what error are you getting?

[Zoud]

$result = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 0,5") OR DIE(mysql_error());

 

That is the correct way, what error are you getting?

 

I just tried it out your way and now it works. Thank you very much!