Hello all, i am trying to query a mysql database to see if a customer all
ready exists in a database and if so then use there customer id to insert
data into another table. Can anyone tell me what valuse mysql returns if the
query returns no value? i have the following code:
If no customers are found, then:
if (mysql_num_rows($result1)==0) {
print theres no such customer!;
}
- Original Message -
From: baldey_uk [EMAIL PROTECTED]
To: Php-General [EMAIL PROTECTED]
Sent: Sunday, April 28, 2002 7:48 AM
Subject: [PHP] failed query results
Hello all, i am
On Sunday 28 April 2002 20:48, baldey_uk wrote:
$customer_id_check=(SELECT id FROM $customer_table WHERE firstname =
'$firstname' lastname = '$lastname' email = '$email');
$result1=mysql_query($customer_id_check);
if (!$result1) {
On 28 Apr 2002 at 13:48, baldey_uk wrote:
$customer_id_check=(SELECT id FROM $customer_table WHERE firstname =
'$firstname' lastname = '$lastname' email = '$email');
$result1=mysql_query($customer_id_check);
if (!$result1) {
4 matches
Mail list logo