php / sql insert script error

[jinx_uk_98]

Hi guys,

I have this sql statement that is trying to insert data from some fields

<?php $con = mysql_connect("xxx","xx","xx"); if (!$con) { die('Could not connect: ' . mysql_error()); }

mysql_select_db("xxx", $con); $sql="INSERT INTO guests (guest_name, guest_email) VALUES"; for($i=0;$i

but it returns the errorError: 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 '' at line 1

[ryan_vietnow]

you have forgotten a period after $sql"

$sql.="INSERT INTO guests (guest_name, guest_email) VALUES";

[jinx_uk_98]

cheers Ryan. have added the period but the error still happens

[nav33n]

Print your query and execute it in mysql console/phpmyadmin.. Also show us the query ..

[jinx_uk_98]

Print your query and execute it in mysql console/phpmyadmin.. Also show us the query ..

not sure what you mean here. please elaborate?

[nav33n]

$sql="INSERT INTO guests (guest_name, guest_email) VALUES";
for($i=0;$i<sizeof($_POST['username']);$i++){

$sql.="('".mysql_real_escape_string($_POST['username'][$i])."','".mysql_real_escape_string($_POST['email'][$i])."')";
if(!$i==sizeof($_POST['username'])){
$sql.=",";
}
}
echo $sql;

What does it print ?

[jinx_uk_98]

oh i understand now.

it prints :
INSERT INTO guests (guest_name, guest_email) VALUES

[nav33n]

Thats it ? Its not entering the for loop ? Well, then there is the problem. Check your for loop and see if the values are being posted.