LIMIT clause

[JohnMeyer]

When you specify a limit clause, do you start at 0 or at 1?
The reason why I ask is that, on one query, it seems to be picking up the 
second record first when I use 1 e.g LIMIT 1, 10.



-
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

What is wrong with this query?

[JohnMeyer]

$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]

Never mind, I figured it out.  Busted link sending me to the wrong file.
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

A way to run winmysqladmin for both 4.0 and 3.2

[JohnMeyer]

I recently downloaded both versions of mysql and would like to run both on 
my computer at once for comparison purposes.  My question is can I do this 
using both winmysqladmin's.  It seems that both products attempt to 
overwrite the my.cnf file in C:\Windows, and I was wondering if there is 
some sort of command line argument I could use to make them use a different 
configuration file?


-
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