insert multiple rows into mysql table - one column from constant value, other from an array

Question

How do insert multiple rows into a mysql table, with one column remaining constant, and the other as an array.

//inserted profession into professions table, return id
$new_profession_id = mysql_insert_id(); 

$qualification_array = array();

foreach ($_POST['qualification'] as $qual){
    array_push($qualification_array, $qual);
}

$query = "???

now how would I insert this into the profession_has_qualification table? its got me stumped...

Sarfraz · Accepted Answer · 2010-11-10 12:35:39Z

2

You can do like this:

$new_profession_id = mysql_insert_id(); 

foreach ($_POST['qualification'] as $qual){
   mysql_query("insert into TableName set pid = $new_profession_id, qualification = '" . mysql_real_escape_string($qual) . "'");
}

answered Nov 10, 2010 at 12:35

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

davivid Over a year ago

great thanks. I was wondering though - is it OK to make many queries like this? or should it be put into one?

Sarfraz Over a year ago

@davivid: Query will run multiple times no matter what after all you want to add more than one record which is not possible with single query :)

Collectives™ on Stack Overflow

insert multiple rows into mysql table - one column from constant value, other from an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related