how to insert records

[ddtpmyra]

I dont know if this a PHP or MYSQL question but im pretty sure its the combination of two.

My problem is how to insert my multiple variable to mysql table in one colum.

example var
$name1
$name2
$name3

employee: column names
id name date

PHP query

      $query = "insert into employee (id, name, date) values ('{$id}','{$name1}',now())";

my problem is how to execute the query one time to insert the above 3 variables to the table?

[hoopy]

Hi something like this:

mysql_query
(" 
  INSERT INTO table (field1, field2) 
  VALUES
  ('$var1', UNIX_TIMESTAMP()), 
  ('$var2', UNIX_TIMESTAMP())
");

That would insert 2 records in one statement.

Cheers.

[hsriat]

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),( 4,5,6),(7,8,9);

http://dev.mysql.com/doc/refman/5.1/en/insert.html

[ddtpmyra]

Grazie! Hoopy and Hriat

[prabirchoudhury]

have a look on some good tutorials on php and mysql tutorial