Jump to content


Photo

query syntax with LIMIT


  • Please log in to reply
1 reply to this topic

#1 kristin Lai

kristin Lai
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 27 March 2006 - 09:02 PM

Hi,
I'm trying create a query that pulls data that fit certain criteria but only pulls so many at a time. I know this means using the LIMIT statement but I don't know what the exact syntax would be. Right now I have:

$queryImg = "SELECT * FROM images LIMIT $limitValue, $f_limit WHERE subID=$subID AND imgFeatured='no'";

I'm getting an error thought so I need to figure out what's wrong with my syntax.

Any suggestions?

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 27 March 2006 - 10:25 PM

Just put it at the end. You may also want to use an ORDER BY clause. You can do ORDER BY RAND() if you want to display random images.

SELECT * FROM images WHERE subID='$subID' AND imgFeatured='no' ORDER BY RAND() LIMIT $startrow, $rows_to_return

Also watch your quoting, leaving $subID bare could expose you to an SQL injection attack, even with magic quotes turned on.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users