INSERT into two tables

[Rick Cummings]

Hi,
I have two events calendars, one public and one private for members.
When an event is posted to the public calendar, it also needs to appear on the private calendar.

This code only posts to the second INSERT statement:

$sql = "INSERT INTO publicevents SET uid=$uid, m=$month, d=$day, y=$year, start_time='$starttime', end_time='$endtime', title='$title', text='$text'";
$sql = "INSERT INTO privateevents SET uid=$uid, m=$month, d=$day, y=$year,start_time='$starttime', end_time='$endtime', title='$title', text='$text'";

Thanks in advance for help with this problem!

Cheers, Rick