simultaneous inserting of row in a databse

[backups2007]

is it possible to insert, say for example, 5 rows of records in a table?

is this possible?

$query1 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 
$query2 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 
$query3 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 
$query4 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 
$query5 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 

[code green]

I think I understand your problem.
Well to start, this is the SQL for multiple record INSERT

INSERT INTO tbl_items (item_code, description) VALUES
('$item_code1', '$description1'),
('$item_code2', '$description2'),
('$item_code3', '$description3'),
('$item_code4', '$description4')

But I understand that $item_code', '$description' variables are changing within your code, but you can approach this in a variety ways.
Build up and create the query within a loop by concatenating strings and variables.
Make $item_code and $description arrays then either extract and concatenate as above or
explode the arrays into the VALUES part of the query.
The best method will depend on the structure of your code so far, but I hope this gives you something to think about,

[backups2007]

ok. thanks for the tip.

could I also use this code?

$query1 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
 
if(query1)
{
     $query2 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
          if(query2)
          {
               $query3 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
               if(query3)
               {
                    $query4 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
                         if(query4)
                         {
                              $query5 = mysql_query("INSERT INTO tbl_items (item_code, description) VALUES ('$item_code', '$description')");
                              if(query5)
                              {
                                echo "insert success";
                              }
                         }
                 }
       }
}
 

Or will this code even work?

[Atli]

Hi.

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

Moderator

[Atli]

Both of the code examples you have posted will work. But they are a little to complicated for what you are trying to do.

As code green said, you can insert multiple rows in a single INSERT statement.

This would do exactly the same thing both your previous code examples do, this would probably be a little faster though:

$query = "
INSERT INTO tbl_items (item_code, description) VALUES 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description')";
 
$result = mysql_query($query);
 

[backups2007]

what if right after inserting the data, I want to get the item code and pass it to another table. say for example,

$query = "
INSERT INTO tbl_items (item_code, description) VALUES 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description'), 
('$item_code', '$description')";
 
$result = mysql_query($query);
 
if($result){
      mysql_query(INSERT INTO inventory (item_code) VALUES ("$item_code"))";
}
 

is this possible?

[code green]

[PHP]$query = "
INSERT INTO tbl_items (item_code, description) VALUES
('$item_code', '$description'),
('$item_code', '$description'),
('$item_code', '$description'),
('$item_code', '$description'),
('$item_code', '$description')";
$result = mysql_query($query);
if($result){
mysql_query("INSERT INTO inventory (item_code) VALUES ("$item_code"))";
}
}[/PHP]

is this possible?

Not sure what you are doing here.
$item_code and $description have only one value throughout.
You are inserting the same values 5 times.
And then inserting the same value of $item_code in to inventory

[Atli]

is this possible?

Of course this is possible. Everything is possible! (within reason)

Try setting up a test server (if you haven't already) and just try it out. It will be a lot quicker than asking us. It's a much better way to learn.

[backups2007]

Of course this is possible. Everything is possible! (within reason)

Try setting up a test server (if you haven't already) and just try it out. It will be a lot quicker than asking us. It's a much better way to learn.

I've already done that. It did worked. Thanks. Xiexie. Arigato. Salamat.