Select from two tables in mysql

admin

Administrator
Staff member
Dear all,

I would like to find out whether userid and password exists in either table parent_user or school_user in the following mysql statement,

$querystring = "select * from parent_user,school_user where (parent_user.userid='$user' and parent_user.password='$pass') or (school_user.userid='$user' and school_user.password='$pass')" ;


But it does not find anything, please help me,thanks

Sincerely yours,
Simon
 
Back
Top