help...possible if mysql can....

[Anon]

i just started using php. is it possible to insert values into multiple tables in mysql? i tried it using the 'while' loop but it doesnt seem to work. here's the sample of my code:

$getusers = "SELECT PID from users";

$gu_result = mysql_query($getusers)
or die("Couldn't get users.");

while ($row = mysql_fetch_array($gu_result)) {

$row_PID = $row["PID"];

$inboxtable = $row_PID . "_inbox";

$sendmeeting = "INSERT INTO $inboxtable (MID, PID) VALUES ('$MID', '$PID')";

$sm_result = mysql_query($sendmeeting)
or die("Couldn't send meeting);

}

thanks for your help!

[Anon]

Sure, you can insert into multiple tables... but not simultaneously. You need to provide more detailed results, what you expected, etc. for anyone to help you further.