Code: Select all
$newpost = @mysql_query("UPDATE newpost SET postID=posts.postID, postdate=NOW()") or die(mysql_error());Moderator: General Moderators
Code: Select all
$newpost = @mysql_query("UPDATE newpost SET postID=posts.postID, postdate=NOW()") or die(mysql_error());Code: Select all
$queries = array();
$queriesї] = "START TRANSACTION;"
$queriesї] = "INSERT INTO table1 VALUES (....)";
$queriesї] = "SELECT @id:=LAST_INSERT_ID() FROM table1";
$queriesї] = "INSERT INTO table2 VALUES(@id, ....)";
$queriesї] = "COMMIT";
foreach($queries as $query)
{
mysql_query($query);
}