RE: [PHP] Unknown column 'peterspeters' in 'where clause'
| From: | Mark Rees | Date: | Wed, 18 May 2005 08:15:56 +0000 |
| Subject: | RE: [PHP] Unknown column 'peterspeters' in 'where clause' | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215447@lists.php.net to get a copy of this message | ||
I expect (indeed I sincerely hope) that customer_username AND
customer_password columns are character datatypes. So it would be a good
idea to put single quotes around the values you are trying to select
from them.
-----Original Message-----
From: Mark Sargent [mailto:powderkeg@snow.email.ne.jp]
Sent: 18 May 2005 07:28
To: php-general@lists.php.net
Subject: [PHP] Unknown column 'peterspeters' in 'where clause'
Hi All,
the below code generates this error,
Unknown column 'peterspeters' in 'where clause'
mysql_select_db("status", $db);
$username = $_POST["username"];
$password = $_POST["password"];
$result = mysql_query("SELECT customer_id FROM Customers WHERE
customer_username = $username AND customer_password = $password") or die
(mysql_error());
$myrow = mysql_fetch_row($result);
$customer_id = $myrow[0];
$_SESSION['customer_id'] = $customer_id;
?>
</head>
<body>
<?php
echo 'SQL Query: '.$result.'<br>';
echo "CustomerID = $customer_id";
?>
Cheers.
Mark Sargent.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Gamma Global : Suppliers of HPCompaq, IBM, Acer, EPI, APC, Cyclades, D-Link, Cisco, Sun
Microsystems, 3Com
GAMMA GLOBAL (UK) LTD IS A RECOGNISED 'INVESTOR IN PEOPLE' AND AN 'ISO 9001
2000' REGISTERED COMPANY
**********************************************************************
CONFIDENTIALITY NOTICE:
This Email is confidential and may also be privileged. If you are not the
intended recipient, please notify the sender IMMEDIATELY; you should not
copy the email or use it for any purpose or disclose its contents to any
other person.
GENERAL STATEMENT:
Any statements made, or intentions expressed in this communication may not
necessarily reflect the view of Gamma Global (UK) Ltd. Be advised that no content
herein may be held binding upon Gamma Global (UK) Ltd or any associated company
unless confirmed by the issuance of a formal contractual document or
Purchase Order, subject to our Terms and Conditions available from http://www.gammaglobal.com
E&OE
**********************************************************************
**********************************************************************