salve a tutti devo effettuare una ricerca su 4 tabella ed ho fatto questo:
Codice PHP:
$sql="SELECT page.ID, Page_it, Content_it, event.Object_it, event.Description_it, Content_it, ";
$sql.="news.Object_it, news.Description_it, Title_it, podcast.Description_it ";
$sql.="FROM page, event, news, podcast WHERE Page_it LIKE '%$research%' OR Content_it LIKE '%$research%' OR ";
$sql.="event.Object_it LIKE '%$research%' OR event.Description_it LIKE '%$research%' Content_it LIKE '%$research%' OR ";
$sql.="news.Object_it LIKE '%$research%' OR news.Description_it LIKE '%$research%' OR Title_it LIKE '%$research%' OR ";
$sql.="podcast.Description_it LIKE '%$research%'";
mysql_query($sql) or die (mysql_error());
mi da questo errore che non capisco da dove proviene:
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 'Content_it LIKE '%italina%' OR news.Object_it LIKE '%italina%' OR news.Descripti' at line 1