LIMIT not working as expected

[bunner_bob]

I'm trying to retrieve the four most recent postings to a database. My basic query (without using "LIMIT" works, but if I try to restrict my results using LIMIT I get an error.

This works:

$result = mysql_query("SELECT cpdonors.first, cpdonors.last FROM cpdonors left join cpdonations ON cpdonors.id = cpdonations.donorid WHERE cpdonations.publish='name' ORDER BY cpdonations.date DESC");
while ($myrow = mysql_fetch_array($result)) {
	echo $myrow['first'] . " " . $myrow['last'] . "<br>";
}

And this doesn't (I get a "not a valid result resource" error):

$result = mysql_query("SELECT cpdonors.first, cpdonors.last FROM cpdonors left join cpdonations ON cpdonors.id = cpdonations.donorid WHERE cpdonations.publish='name' ORDER BY cpdonations.date DESC LIMIT(0,4)");
while ($myrow = mysql_fetch_array($result)) {
	echo $myrow['first'] . " " . $myrow['last'] . "<br>";
}

Of course maybe I'd just be better off doing a for loop on the whole result with $i <= 4... suggestions?

[kristianblom]

Try this:
Instead of LIMIT(0,4)

LIMIT 4 ( this should work just fine)

or

OFFSET 0 LIMIT 4

[siwis]

remove the parentheses

SELECT cpdonors.first, cpdonors.last FROM cpdonors left join cpdonations ON cpdonors.id = cpdonations.donorid WHERE cpdonations.publish='name' ORDER BY cpdonations.date DESC LIMIT 0,4 

[dnszero]

You need to leave the parenthesis out of your LIMIT, just do

...cpdonations.date DESC LIMIT 0,4");

and it should work fine.

[bunner_bob]

Ahh yes - thanks!