con esto:
Código PHP:
if ($_GET["campo"]=="contiene") {
$_pagi_sql="SELECT * FROM astur WHERE ";
for ($i=0;$i<count($_GET['select'])-1;$i++){
$_pagi_sql.="".$_GET["select[$i]"]." LIKE '%".$_GET["palabra"]."' or";
}
$_pagi_sql.="".$_GET["select[$i]"]." LIKE '%".$_GET["palabra"]."'' ORDER BY ".$_GET["ord"]." ASC";
echo $_pagi_sql;
}
me sale el siguiente mensaje de error:
Notice: Undefined index: select[0] in C:\sokkit\site\asturnatura\Consultas\rbuscador.php on line 137
Notice: Undefined index: select[1] in C:\sokkit\site\asturnatura\Consultas\rbuscador.php on line 139
SELECT * FROM astur WHERE LIKE '%dori' or LIKE '%dori'' ORDER BY Especie ASCYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%dori' or LIKE '%dori'' ORDER BY Especie ASC' at line 1
sabe alguien a que se debe?