barney

The below query throws an error: Warning: mysql_num_rows(): supplied
argument is not a valid MySQL result resource
I think it is unhappy about the constant in the LIMIT

What am I doing wrong?

SELECT
dms_user_logs.user_log_id,
dms_user_logs.user_log_date,
dms_users.dms_user_id,
dms_users.dms_user_first_name,
dms_users.dms_user_middle_name,
dms_users.dms_user_last_name
FROM
dms_user_logs,
dms_users
WHERE
dms_users.dms_user_id = dms_user_logs.dms_user_id
LIMIT
$start, PAGINATION_COUNT
ORDER BY
user_log_id DESC