$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
- Re: What is wrong with this query? JohnMeyer
- Re: What is wrong with this query? JohnMeyer
- What is wrong with this query? Mark