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