If customer_username is a string (char, varchar, text etc.) then I guess it
should be
mysql_query("SELECT customer_id FROM Customers WHERE customer_username =
\"$username\" AND customer_password = \"$password\"")
Prathap
---------- Original Message -----------
From: Mark Sargent <powderkeg@xxxxxxxxxxxxxxxx>
To: php-general@xxxxxxxxxxxxx
Sent: Wed, 18 May 2005 15:27:34 +0900
Subject: 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
------- End of Original Message -------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
