SQL sending 4 SQL querys at once

[exile]

I have to add entrys to 4 tables. If something goes wrong and it gets cut off, the whole database indexing is messed up. how can i process the 4 entrys at once in php?
ill get the code a little later, dont have it with me right now.

 

[Emily]

I'm not sure if this is what you mean, but would something like this work?

$sql = "INSERT INTO table ('field') VALUES ('$value')";
$sql1 = "INSERT INTO table ('field') VALUES ('$value1')";
$sql2 = "INSERT INTO table ('field') VALUES ('$value2')";
$sql3 = "INSERT INTO table ('field') VALUES ('$value3')";

if ((mysql_query($sql, $db)) && (mysql_query($sql1, $db)) && (mysql_query($sql2, $db)) && (mysql_query($sql3, $db))) {

echo "Success";

} else {

echo "Failure";

}

 

[gruntwerk]

see http://www.mysql.com/doc/en/COMMIT.html
if you use transaction safe tables this handles it for you...

 

[exile]

here is the actual code

The basic code is here: http://wrjournal.net/sqlcode.php.txt
this is just the basic sql querys.

(if you goto my home page, you will see why im redesigning the site)