php/mysql limit function, help

[nobody]

Hey guys and gals.
I'm trying to pull the top two rows off of my mysql database through php, sorting by ID. I'm just having a sliiiight problem doing it. This is the code I'm using to query the database at the moment.


$query = mysql_query( " SELECT * FROM mainpage WHERE page = 1 ORDER BY ID DESC LIMIT 0 , 2 " );

[binime]

Hey guys and gals.
I'm trying to pull the top two rows off of my mysql database through php, sorting by ID. I'm just having a sliiiight problem doing it. This is the code I'm using to query the database at the moment.


$query = mysql_query( " SELECT * FROM mainpage WHERE page = 1 ORDER BY ID DESC LIMIT 0 , 2 " );


$query = mysql_query( " SELECT * FROM mainpage WHERE page = 1 ORDER BY id DESC LIMIT 2 " );

[SlowRoasted]

yeah what he said:)

[Yeldarb]

Actually if you want the top 2, as in the first two, it would need to be:

$query = mysql_query("SELECT * FROM mainpage WHERE page=1 ORDER BY id ASC LIMIT 2");

[nobody]

Thanks guys. I did that before but obviously I did something wrong because it gave me an error :P

Thank you:beam:

[Voetsjoeba]

If I remember correctly, to select a range (for example 2,4) you need to put brackets around the numbers:



$query = mysql_query( " SELECT * FROM mainpage WHERE page = 1 ORDER BY ID DESC LIMIT (0,2) " );


But since 0,2 is the same as 2, just use LIMIT 2 as said above.

[nobody]

Thanks voets :)