Please help! i am troubling about on how can i execute my sql script properly. Thanks!Here's my code
$sql="INSERT INTO inventory(account_number,serial_number,locator,remarks,`date_assigned`) VALUES('$accountno','$serial','$locator','$remarks',NOW())";
$sql.="INSERT INTO action_log(action,username,`date`) VALUES ('assigns the box($serial) to $accountno','$user',NOW())";
$sql.="INSERT INTO account_logs(action_log,account_number,username,`date`) VALUES('Assign','$accountno','$user',NOW())";
if(mysql_query($sql)){echo "Successfully Assigned!";}
else{echo "Insertion Failed!";}