Confirmed, this works for me.
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id in ('1','2') ";
Confirmed, this works for me.
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id in ('1','2') ";
Thanks for getting back to me.
I've just tried this:
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id in ('4','5','7') ";
However, it only let's the first admin on the list login, none of the others.
Any idea why?
I can see where "in" will not work under the current design. There is no loop to check each value.
Hi,
Thanks for replying. Do you know of something else that would work instead of 'in'?
Thanks.
I should start all my comments with "I could be wrong". The answer to your question above is, no. "IN", is correct. What needs work is a loop to review the table returned by the SQL. That work is not in my current plans.
Hi there,
OK, thanks for letting me know.
Fergus
And I thank you for bringing my incorrect responses to my attention. d^b