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());