errore 1064 SQL syntax
Inviato: 06/10/2005, 11:08
qualcuno sa dirmi che tipo di errore è questo? e come si corregge?
compare quando eseguo una ricerca (ad esempio "Mario") tra i miei clenti
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where c.customers_lastname like '%carone%' or c.customers_first
select count(*) as total from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id and c.customers_id = ci.customers_info_id where c.customers_lastname like '%carone%' or c.customers_firstname like '%carone%' or c.customers_email_address like '%carone%'
grazie..
compare quando eseguo una ricerca (ad esempio "Mario") tra i miei clenti
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where c.customers_lastname like '%carone%' or c.customers_first
select count(*) as total from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id and c.customers_id = ci.customers_info_id where c.customers_lastname like '%carone%' or c.customers_firstname like '%carone%' or c.customers_email_address like '%carone%'
grazie..