Page 1 of 1

whats wrong with this insert code?

Posted: Mon Jul 02, 2007 5:38 pm
by 303tech

Code: Select all

[php]$id=$_GET['id'];

$insert="INSERT INTO customer (unitname, sec1, sec2, sec3, sec4, sec5, sec6, ip) SELECT ('$replace', '$sec1', '$sec2', '$sec3', '$sec4', '$sec5', '$sec6', '$ip') WHERE id=$id";
mysql_query($insert);[/php]
i cant seem to figure this one out

Posted: Mon Jul 02, 2007 5:43 pm
by volka
try

Code: Select all

$id=$_GET['id'];

$insert="INSERT INTO customer (unitname, sec1, sec2, sec3, sec4, sec5, sec6, ip) SELECT ('$replace', '$sec1', '$sec2', '$sec3', '$sec4', '$sec5', '$sec6', '$ip') WHERE id=$id";
echo '<div>Debug: ', htmlentities($insert), "</div>\n";
mysql_query($insert) or die(mysql_query());