Re: SELECT statement

Try or print mysql_error () rather than or die ( print mysql_error () )? Peter Houchin wrote:

I've tried this but mysql_error() doesn't give me any errors, i tried my sql line at the command line with success here is my code if some one could have a look at it and give some suggestions as to how i can get the email ... Thanks again Peter <? session_start(); if ($REQUEST_METHOD=='POST') { header('Expires: ' . gmdate("D, d M Y H:i:s", time()+1000) . ' GMT'); header('Cache-Control: Private'); } session_register('user'); session_register('pass'); session_register('email'); $session = session_id(); $userid = '$user'; ?> <html> <head> <title>eRentals</title> </head> <body> <? // connect to data base $open = mysql_connect("localhost", "root", "password")

    or die ("<font face=\"Helvetica, sans-serif\" size=\"3\"

color=\"#006699\">Unable to connect to server.</font>"); mysql_select_db("rentdb")

    or die ("<font face=\"Helvetica, sans-serif\" size=\"3\"

color=\"#006699\">Unable to select database.</font>"); // select id & email from table matching the user name and password inputted $sql = "SELECT id, email FROM users WHERE user='$user' and pass='$pass'"; $result = mysql_query($sql)

    or die (print mysql_error());

// if unsuccessfull do this $num = mysql_numrows($result)

    or die ("

<font face=\"Helvetica, sans-serif\" size=\"3\" color=\"#006699\">You're not authorized to be here. If you feel you have recieved this<BR> message in error, please contact the <a href=\"mailto:peterh@v.com\">webmaster</a></font> "); // if successful then do this if ($num == 1) { include "quote2.php"; //has a hidden field referencing the user & the email address .. user shows up but again email does not } ?> </body> </html> -----Original Message----- From: Philip Olson [mailto:philip@cornado.com] Sent: Tuesday, February 13, 2001 4:59 PM To: Peter Houchin Cc: PHP MAIL GROUP Subject: RE: [PHP] SELECT statement A possible way to find out :

    $result = mysql_query($sql) or die(mysql_error());

Does it say anything? mysql_error() is your friend, it can be printed anywhere within the script and will print the last mysql error. So perhaps :

    print mysql_error();

Right before the query or ... Regards, Philip On Tue, 13 Feb 2001, Peter Houchin wrote:

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net