Jump to content


Photo

PHP/MySQL query problem


  • Please log in to reply
2 replies to this topic

#1 ericc59

ericc59
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 27 July 2006 - 03:08 AM

Can anyone tell me why this query would return 49 results instead of 25?

$query = "SELECT id FROM forum_threads WHERE forum='2' ORDER BY id DESC LIMIT 25, 50";

Thanks,
Eric

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 27 July 2006 - 03:14 AM

Because your telling it to return 50 results starting at result number 25.

#3 ericc59

ericc59
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 27 July 2006 - 03:25 AM

Oh, ok. Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users