[Resolved] LIMIT not working?

phpjaco

ok, everyhting is working fine except my LIMIT is not limiting, here is the code :

$sql = "select * from article where permanent_submit = \"yes\" ORDER BY article_date DESC LIMIT 3";

have looked at the mysql book and seems that this does follow the right syntax and order but it just gives me all the records.

what am i doing wrong?

tsinka

Hi,

please post the complete part of the code (copy'n'paste) that executes that query.

Thomas

phpjaco

// displays the latest articles
$sql = "select * from article where permanent_submit = \"yes\" AND hot_topic = \"yes\" ORDER BY article_date DESC LIMIT 3";
$rs = mysql_query($sql, $conn);
$num = mysql_numrows($rs);
if ($num > 0) {
...
the rest is pretty much just a table

pinehead18

try LIMIt 0, 3

TheDefender

The LIMIT 3 should be fine, because if the offset isn't defined, it defaults to 0.

I am wondering why you are escaping the double quotes in the sql though..

Change this:

$sql = "select * from article where permanent_submit = \"yes\" AND hot_topic = \"yes\" ORDER BY article_date DESC LIMIT 3";

to this:

$sql = "select * from article where permanent_submit = 'yes' AND hot_topic = 'yes' ORDER BY article_date DESC LIMIT 3";

and see if that helps as well...

tsinka

Hi,

looks ok so far ... please post the complete code (maybe as attachment).

Thomas

phpjaco

that solved the problem, just dont understand why cause both statements say the same thing.

but will use '$var' instead of \"$var\" from now.

thanx

TheDefender

Yeah, that's fine in an echo, but it is interpreted a bit differently when in a SQL statement. I am not sure why, but it's been my experience in the past to avoid using double-quotes in the MySQL. I think it has something to do with the fact that it's being utilized by MySQL at that point... but I am not 100% of the exact reason.