Sistema de busqueda por selects

[phpfan]

ah Esto es un desastre mira lo que sale :


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 ''%%','%%','%%') AS Score FROM tabla
WHERE MATCH (name1,nam' at line 1 SELECT SQL_CALC_FOUND_ROWS name1,name2,name3,name4 MATCH (name1,name2,name3,name4) AGAINST ('%%','%%','%%','%%') AS Score FROM tabla WHERE MATCH (name1,name2,name3,name4) AGAINST ('%%','%%','%%','%%') ORDER BY Score




Eh, usado estos terminos de busqueda y nada de nada. creo que las e usado todas ya no me queda obcion.


#$result = mysql_query( "SELECT * from tabla WHERE name1,name2,name3,name4 LIKE '%{$_GET['palabra']}%' ");


#$result = mysql_query( "SELECT * , MATCH(name1,name2,name3,name4) AGAINST ('%{$_GET['palabra']}%') as Score FROM tabla WHERE MATCH(name1,name2,name3,name4) AGAINST ('%{$_GET['palabra']}%') ORDER BY id_sql ");


ya nose que mas hacer.