A
Anonymous
Guest
I am trying to do a multiple insert.
$sdcount=10;
for ($i=0;$i<$stdcount;$i++){
$query = "Insert into $mysql_cat (id, user, category) values ('', '$user','$category[$i]')";
$result = mysql_query($query) or die("ERROR: cannot INSERT data into database");
}
// for ($i = 0; $i < $stdcount; $i ++)
?>
<form method=post>
<input type="text" name="category[]">
<input type="text" name="category[]">
<input type=hidden name=sdcount value=$sdcount>
<input type="submit" value="Upload/Submit">
</form>
$sdcount=10;
for ($i=0;$i<$stdcount;$i++){
$query = "Insert into $mysql_cat (id, user, category) values ('', '$user','$category[$i]')";
$result = mysql_query($query) or die("ERROR: cannot INSERT data into database");
}
// for ($i = 0; $i < $stdcount; $i ++)
?>
<form method=post>
<input type="text" name="category[]">
<input type="text" name="category[]">
<input type=hidden name=sdcount value=$sdcount>
<input type="submit" value="Upload/Submit">
</form>