TalkPHP - View Single Post

tony · 05-31-2011, 01:18 AM

That is because you have:

PHP Code:

$query="INSERT INTO orders (ORDER_DESC) VALUES ('".$order."' )";

which when it is looping it is replacing the query. Instead try assemble the query. like this:

PHP Code:

if(count($orders)>0)
{
  $query = 'INSERT INTO orders (ORDER_DESC) VALUES ';
  //you could loop through it
  /*
  foreach($orders as $order)
  {
    $query .= "('".$order."'), ";
  }
  */
  //or just use implode
  $query .= "('".implode("'), ('", $orders)."')";
  
  //if you used the implode function you don't need this next line
  $query = trim(', ', $query).';';
  mysql_query($query) or die ('Error Updating the Database' . mysql_errno());
  echo "Order Successfully Placed";
}

that would create something like this:

SQL Code:

INSERT INTO orders (ORDER_DESC) VALUES ('CSF'), ('LFT'), ('RFR');

which is how you query a mysql database to insert multiple records.