LIMIT clause

2002-11-20 Thread 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://ww

Re: What is wrong with this query?

2002-11-19 Thread 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(

What is wrong with this query?

2002-11-19 Thread 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 u

A way to run winmysqladmin for both 4.0 and 3.2

2001-11-24 Thread 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 som