Re: returning username/pass from 2 tables

2006-08-15 Thread Mike van Hoof
Renato Golin schreef: [EMAIL PROTECTED] wrote: How do I check two tables is it? Username and userpass are submitted through a from and are unique $sql = "SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND userpass = '$userpass'"; This way you'll have an ambigu

Re: returning username/pass from 2 tables

2006-08-15 Thread Renato Golin
[EMAIL PROTECTED] wrote: How do I check two tables is it? Username and userpass are submitted through a from and are unique $sql = "SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND userpass = '$userpass'"; This way you'll have an ambiguous error as username a

returning username/pass from 2 tables

2006-08-15 Thread ross
How do I check two tables is it? Username and userpass are submitted through a from and are unique $sql = "SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND userpass = '$userpass'"; Ta, Ross