I'm trying to check if informations provided by new users are already in my
database. Things like email address, cellphone number and user name.
Right now I'm asking this way:
SELECT username, email, user_mobile_number FROM user_dossier_tbl AS ud,
user_login_tbl AS ul WHERE
(email="com" OR user_mobile_number="1234567890" OR
username="tom") AND ud.user_id = ul.user_id;
As a response I'm getting table with all existing user login names, emails
and cellphone numbers ... then im parsing it with PHP.
I was trying to find a way to ask MySQL in the way that the output table
would be in a form:
loginname | ...