Insert Data Help

[melaniehayes]

okay, here's my though - just not sure how to make it work. Instead of leaving several products' information parsed with two delimiters in a cart field - I was thinking about how to put that info into it's own products table. Right now fields are terminated by ":" and Lines are terminated by "~"

script so far:

$orders = mysql_query("SELECT id, cart FROM orders");
$row = mysql_fetch_array($orders);

do {
$product_entry = $row["id"] : $row["cart"]

INSERT into order_products $product_entry FIELDS TERMINATED BY ":" LINES TERMINATED BY "~";

} while ($row = mysql_fetch_array($orders));

I know the way I have it listed in the do while loop is not right, but that's the part I don't know how to write. Can someone help me with this?

I have the order_products table created with the datatypes set for each field, as well as a record id so I can pull all the records that match the order id.

Thanks,
Melanie

[barand]

Instead of

$orders = mysql_query("SELECT id, cart FROM orders");
$row = mysql_fetch_array($orders);

do {
$product_entry = $row["id"] : $row["cart"]

INSERT into order_products $product_entry FIELDS TERMINATED BY ":" LINES TERMINATED BY "~";

} while ($row = mysql_fetch_array($orders));

Try something like

$orders = mysql_query("SELECT id, cart FROM orders");

while ($row = mysql_fetch_array($orders) ) {
$sql="INSERT INTO order_products(id,cart) values ($row["id"],$row["cart"])"
mysql_query($sql)
}

HTH