Jump to content


Searching 2 mysql tables for username and password

  • Please log in to reply
No replies to this topic

#1 rossco100

  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 April 2006 - 01:12 PM

i have created a site where the user logs in with an assigned username and password, on login they are asked to enter their prefared username and password to login with in the future.
I have 2 MySql tables piclogin (original table with preset details)
and newlogin which stores the new prefered username and passwords,

I used the coding below to do the original validation :

if($rec=mysql_fetch_array(mysql_query("SELECT * FROM piclogin WHERE username='$username' AND password = '$password'"))){

my question is: can a query be created to search both tables for the username and password entered? and depending on which table the information is found in, redirect the user to different web pages?


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users