[SOLVED] Inserting to two different tables simultaneously

[Lambneck]

Im trying to insert data into two seperate tables with in the same process.

 

So far I have the following being inserted into one table, but I want to have $tags inserted into another table(blog_tags). Can anyone help me?

if ( isset($_POST['submit']) ) {

require_once('load_data.php');

$connect = mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($database);

$title = mysql_real_escape_string($_POST['title']);
$post = mysql_real_escape_string($_POST['post']);
$category = mysql_real_escape_string($_POST['category']);
$tags = mysql_real_escape_string($_POST['tags']);
    $ip = $_SERVER['REMOTE_ADDR'];

   $insert = mysql_query("INSERT INTO $table (title, post, category, ip_address) VALUES ('$title', '$post', '$category', '$ip')") or die(mysql_error());
} 
header('Location: ../');
exit();

[DarkendSoul]

Is there a problem with just inserting again after? o.o;

 

if ( isset($_POST['submit']) ) {

 

 

 

require_once('load_data.php');

 

 

 

$connect = mysql_connect($db_host, $db_user, $db_pwd);

 

 

 

mysql_select_db($database);

 

 

 

 

 

 

$title = mysql_real_escape_string($_POST['title']);

 

 

 

$post = mysql_real_escape_string($_POST['post']);

 

 

 

$category = mysql_real_escape_string($_POST['category']);

 

 

 

$tags = mysql_real_escape_string($_POST['tags']);

    $ip = $_SERVER['REMOTE_ADDR'];

 

  $insert = mysql_query("INSERT INTO $table (title, post, category, ip_address) VALUES ('$title', '$post', '$category', '$ip')") or die(mysql_error());

 

  $insert_more = mysql_query("INSERT INTO blog_tags ...") or die(mysql_error());

 

}

header('Location: ../');

exit();[/php

[Lambneck]

Oh! I didnt think that could work Thanks!

One more question about this.

I want to get the id of the data in the first table to be inserted into a row in the table of the second insert.

Does that make sense? (its  been a long day)

[DarkendSoul]

http://ca.php.net/manual/en/function.mysql-insert-id.php