Can i insert into more than one table within one insert query using PHP and mySQL??
example:
[code=php]mysql_query(“INSERT INTO $db_table ( `event_id` , `event_day` , `event_month` , `event_year` , `event_time` , `title` , `description` , `type_event` ) VALUES (”, ‘$_POST[day]’, ‘$_POST[month]’, ‘$_POST[year]’, ‘$_POST[hour]:$_POST[minute]’, ‘$_POST[title]’, ‘$_POST[description]’ , ‘$_POST[type_event]’)”);
of course:
[code=php]$db_table = $TBL_PR = “events”;
and $TBL_PR = “events”;
but if i change
[code=php]$TBL_PR = “events”;
to
[code=php]$TBL_PR = “events, second_table, third_table, forth_table”;
Can this work, or would i have to make seperate Insert into query’s for every other table i want to insert data into and retrive from???
thanks ?