Hello,
I have 2 tables, one for users, and one for webmasters. Both of them have a username field. When one signs up, i want to check both tables at once, to see if there are any of the same usernames. I am using this query:
select user_info.username as u, webmaster_info as w from webmaster_info, user_info where webmaster_info='$email' or user_info.username='$email';
It doesnt return any results even though i know there should be. webmaster_info has one record with the email im looking for. user_info does not have any records.
Thanks
Bill Van pelt
I have 2 tables, one for users, and one for webmasters. Both of them have a username field. When one signs up, i want to check both tables at once, to see if there are any of the same usernames. I am using this query:
select user_info.username as u, webmaster_info as w from webmaster_info, user_info where webmaster_info='$email' or user_info.username='$email';
It doesnt return any results even though i know there should be. webmaster_info has one record with the email im looking for. user_info does not have any records.
Thanks
Bill Van pelt