There must be some funny problem. You code looks alright.
Try to output mysql_error() in your code to see what happens. Or simply try
it from command line.
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-----Original Message-----
From: Peter Houchin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:51 PM
To: PHP MAIL GROUP
Subject: RE: [PHP] SELECT statement
ok I've changed my code to
$sql = "SELECT id, email FROM users WHERE user='$user' and pass='$pass'";
but still no joy can any one suggest why?
(& Yes email is a field in the table)
Peter
> Hi,
>
> Can you have a SELECT statement (using mysql) that goes something like
>
> $sql="SELECT id && email FROM table WHERE user='$user' and pass='$pass'";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
