Insert Multiple Items into the DB at the same time

[jbachris]

I have this code for entering data into my tables:

<?

require ( "databaseconnex.php" );

if ( $_POST['add_site'] ) {

$sql = 'INSERT INTO cm_site ( site_url, site_title ) VALUES (' . $_POST['site_url'] . ',' . $_POST['site_title'] . ')';
$add_rating_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );

header ( "Location: home/" );
exit;	

}

?>

I have this code/forms in my page:

URL:<input type="text" name="site_url" id="site_url" >
<br /><br />
TITLE: <input type="text" name="site_title" id="site_title" />
<hr />
URL:<input type="text" name="site_url2" id="site_url2" >
<br /><br />
TITLE: <input type="text" name="site_title2" id="site_title2" />

What I want to do is enter both sets of entries into the DB at the same time, as different rows in the table.

[Joseph07]

Adding another SQL statment but change the value to be inserted.

[NogDog]

You can have multiple value sections:

INSERT INTO table name (col_1, col_2) VALUES ('val_11', 'val_12'), ('val_21', 'val_22')