Guess that's what you get when you don't check the most obvious thing, like the address file.
At 07:42 PM 11/19/2002 -0700, JohnMeyer wrote:
$strQuery = "SELECT users.UserID,UserAIM,FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age,UserFName,UserLName,UserDOB,UserCity,UserState,UserEmail,UserSchoolName,UserSchoolType FROM users, user_interest where users.UserID=user_interest.UserID and user_interest.InterestID=" . $_GET["id"] . " ORDER BY UserAIM LIMIT " . (($_GET["offset"] * 10) - 9) . ",10";
offset is a number that corresponds to the 10 of a query (example, 2 offset would translate into 20, or 2*10-9. When offset is 1, it works, but when it's 2, it just dumps all of the records.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
