Re: [PHP] failed query results

2002-04-28 Thread David Freeman
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

Re: [PHP] failed query results

2002-04-28 Thread Jason Wong
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 (!$r

Re: [PHP] failed query results

2002-04-28 Thread Richard Emery
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 que

[PHP] failed query results

2002-04-28 Thread baldey_uk
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: $customer_id_check=("