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

barney

So is the value a zero? Why not set its initial value to 1, so you get
a result set with some rows in it?
SELECT ... FROM ... LIMIT 0 returns no rows, hence mysql_num_rows() is
tossing an error.

That said, if there is any chance there will/could be an empty
recordset, you should always test for that before doing anything else
with the result.

barney

The error Karl was getting was "not a valid MySQL result resource". A
record-set with zero rows is still a valid resource. The error message
means there was an error in the MySQL query itself.
Karl, since you are spanning databases, it may be that your ORDER BY
expression does not reference a database name, like all your other
values. Just a first guess...