ZUL W3C COMPLIANCE NUKE

maisarrah · Teman Baru

Assalam, tumpang tanya, macam nak simpan data yang value value foreign keys. saya cuba tapi ada error.

if (isset($_POST['add'])){

$sqlx="SELECT event_id FROM booking_event WHERE event_id = '$event_id'";
while($row =mysql_num_rows(mysql_query($sqlx))>0){

$cl_fk= $row['event_id'];
}
$bfood_date = addslashes($_POST['bfood_date']);
$bfood_menu= addslashes($_POST['bfood_menu']);
$bfood_venue = addslashes($_POST['bfood_venue']);
$bfood_pax = addslashes($_POST['bfood_pax']);
$bfood_type = addslashes($_POST['bfood_type']);
$bfood_remark=addslashes($_POST['bfood_remark']);
$bfood_status=addslashes($_POST['bfood_status']);

$sajian="INSERT INTO booking_bfood SET bfood_date='$bfood_date',bfood_menu='$bfood_date',bfood_venue='$bfood_venue',
bfood_pax='$bfood_pax',bfood_type='$bfood_type',bfood_remark='$bfood_remark',bfood_status='$bfood_status',
event_booking_id = (SELECT event_booking_id FROM booking_event WHERE event_id = '$cl_fk')";

$result_2 = mysql_query($sajian);
if ($result_2)
//echo 'Pengisian maklumat berjaya';
echo "<script language='javascript'>window.location='sajian_view.php?event_booking_id=$event_booking_id'</script>";

else
echo 'Pengisian maklumat gagal';

}