Código PHP:
Ver original
<? $cambios.=", nb1='" . $_POST["nb1"] . "'"; $cambios.=", nb2='" . $_POST["nb2"] . "'"; $cambios.=", nb3='" . $_POST["nb3"] . "'"; $cambios.=", nb4='" . $_POST["nb4"] . "'"; $cambios.=", nb5='" . $_POST["nb5"] . "'"; $cambios.=", nb6='" . $_POST["nb6"] . "'"; $cambios.=", nb7='" . $_POST["nb7"] . "'"; $cambios.=", nb8='" . $_POST["nb8"] . "'"; $sql = 'select img1,img2,img3,img4,img5,img6,img7,img8 from slider WHERE id= ' . $_POST["id"]; if ($HTTP_POST_FILES['img1']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img1']['name']; $img2 = $HTTP_POST_FILES['img1']['name']; if ($rowFotos["img1"]!="") { } $cambios.=", img1='" . $img1 . "'"; } if ($HTTP_POST_FILES['img2']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img2']['name']; $img2 = $HTTP_POST_FILES['img2']['name']; if ($rowFotos["img2"]!="") { } $cambios.=", img2='" . $img2 . "'"; } if ($HTTP_POST_FILES['img3']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img3']['name']; $img2 = $HTTP_POST_FILES['img3']['name']; if ($rowFotos["img3"]!="") { } $cambios.=", img3='" . $img3 . "'"; } if ($HTTP_POST_FILES['img4']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img4']['name']; $img2 = $HTTP_POST_FILES['img4']['name']; if ($rowFotos["img4"]!="") { } $cambios.=", img4='" . $img4 . "'"; } if ($HTTP_POST_FILES['img5']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img5']['name']; $img2 = $HTTP_POST_FILES['img5']['name']; if ($rowFotos["img5"]!="") { } $cambios.=", img5='" . $img5 . "'"; } if ($HTTP_POST_FILES['img6']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img6']['name']; $img2 = $HTTP_POST_FILES['img6']['name']; if ($rowFotos["img6"]!="") { } $cambios.=", img6='" . $img6 . "'"; } if ($HTTP_POST_FILES['img7']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img7']['name']; $img2 = $HTTP_POST_FILES['img7']['name']; if ($rowFotos["img7"]!="") { } $cambios.=", img7='" . $img7 . "'"; } if ($HTTP_POST_FILES['img8']['name']!="") { $nombre_archivo = "../images/botellas/" . $HTTP_POST_FILES['img8']['name']; $img2 = $HTTP_POST_FILES['img8']['name']; if ($rowFotos["img8"]!="") { } $cambios.=", img8='" . $img8 . "'"; } $sql = 'Update slider SET ' . $cambios . ' WHERE id= ' . $_POST["id"]; ?>
al pulsar en actualizar me salta el mysql_error:
"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 ' nb1='jb', nb2='bombay', nb3='beefeater', nb4='cacique', nb5='smirnoff', nb6='pa' at line 1"
ayuda please...
