mysql_fetch_row（）不是有效的结果资源

Question

I am confused, I don't know what's wrong. I'm about to transfer all data from my first table to the other. Here is my code:

$getdata = mysql_query("SELECT Quantity, Description, Total FROM ordercart");

while($row = mysql_fetch_row($getdata))
{
foreach($row as $cell){

$query1 = mysql_query("INSERT INTO ordermem (Quantity, Description, Total) VALUES 
($cell)",$connect);

}
mysql_free_result($getdata);
}

I get the error: Warning: mysql_fetch_row(): 5 is not a valid MySQL result resource.

Answer 1

You only pass one value in the INSERT, which expects three values to be passed to the fields Quantity, Description, Total:

INSERT INTO ordermem (Quantity, Description, Total) VALUES 
($cell);

Change it to:

INSERT INTO ordermem (Quantity, Description, Total) VALUES 
($cell, $descriptionParam, $totalParam);

You may also try to use INSERT INTO SELECT directly instead of two distinct statements like so:

INSERT INTO ordermem (Quantity, Description, Total)
SELECT Quantity, Description, Total FROM ordercart;