"connected but not to table" MySQL-Link

Warning: Supplied argument is not a valid MySQL-Link resource

I get the above error for one query -

"SELECT * FROM $user_tablename ORDER BY $order_field $default_sort_order LIMIT $limit_str_edit"

while other queries do not return this error.
Is this a PHP bug?
The error occurs on different web hosts.

thanks for any replies,
dale

run the code again, but this time, don't run the query directly,

set $QStr = to your query, then echo $QStr, then mysql_query($QStr)

there may be some problem in the variables, and when you echo $QStr, you see exactly what your query looks like.

paul13

No bug.

"Supplied argument is not a valid MySQL-Link resource "

means that the query could not be executed because there was no connection to the database.

Most likely you made a typo in the name of the variable that holds the database connection.