Multiple row insert via query?

Trent_Hatred

Hey everyone,

I'm sure this has been answered, but I've scoured the boards and all I could find was multiple inserts via forms.

What I'm trying to do is insert multiple rows into the items table of my database via a query. Below is the code I have thus far (no inserts etc.).

As you can see, it just loops through, grabbing all relevant entries and displays them (there are usually more fields, I've cut the code down to just 1 for troubleshooting).

<?php
$query = "SELECT * FROM orderItems o, items i
WHERE o.itemID = i.itemID
AND o.orderID = '$_POST[orderID]'";

$result = mysql_query($query) or die("Select Failed!");
$num=mysql_numrows($result);

$i=0;
while ($i < $num) {

$description=mysql_result($result,$i,'description');

?>
<tr>
<td align="left" class="table_cell_alt"><? echo "$description"; ?></td>
</tr>
<?
++$i;
}
?>

What I need to do is have each row returned placed into an array and inserted. So if there are 4 descriptions, I hope to insert 4 new descriptions into the items table (with new itemIDs via autoincrement).

I've looked into using something similar to:

for($i = 0; $i < count($array1); $i++) {

echo $array1[$i];
echo $array2[$i];
echo $array3[$i];
}

but I'm just now sure how to incorporate that into my current code...

Thanks, and I hope that makes sense.
B

LordShryku

Well, considering you're just inserting based on a select statement, you could do this all in SQL. Now, this would need some tweaking depending on the differences in the tables, but if the tables are exactly the same, you could do something like this

INSERT INTO items
     SELECT * 
       FROM orderItems o, items i
      WHERE o.itemID = i.itemID
        AND o.orderID = '$_POST[orderID]'

Though, your statement doesn't make a whole lot of sense, since doing a select *(which is ambigouis). So like I said; may need some tweaking.

Trent_Hatred

Originally posted by LordShryku
Well, considering you're just inserting based on a select statement, you could do this all in SQL. Now, this would need some tweaking depending on the differences in the tables, but if the tables are exactly the same, you could do something like this
INSERT INTO items
     SELECT * 
       FROM orderItems o, items i
      WHERE o.itemID = i.itemID
        AND o.orderID = '$_POST[orderID]'
Though, your statement doesn't make a whole lot of sense, since doing a select *(which is ambigouis). So like I said; may need some tweaking. [/B]

Hi LordShryku,

What I was hoping to have happen is, after displaying the items, there would be a submit button which when pressed would essentially duplicate the items in the items table (with a new autoincrement number).

So, for orderID #15 which has 3 items, those items would be stored in an array when displayed. Then, when the submit button is pressed, the insert statement would enter them as new items into the items table.

I'm having problems with placing all of the information into an array.