insert into multiple tables

Can someone please help me w/the following code? I'm trying to insert data

collected on a form into two tables into my database. I          know the

SQL statements work because I tested them individually, but I keep getting

the error "Couldn't execute query 2". Does               anyone have any

suggestions? Thanks in Advance Toni <?php $sql = "INSERT INTO users (fname, lname, compid, status, dept, room, bldg,

phone) VALUES ('$fname', '$lname', '$compid',                   '$status',

'$dept', '$room', '$bldg', '$phone')"; $sql1 = "INSERT INTO tickets (ticket_num, compid, date_rpt, time_rpt, request_type, hardware, model, dci, dci_num, software_type, software_pkg, problem, comments, entered_by) VALUES ('$ticket_num', '$compid', '$date_rpt', '$time_rpt', '$request_type', '$hardware','$model','$dci','$dci_num','$software_type','$software_pkg','$problem','$comments','$entered_by')"; /*create connection*/ $connection = mysql_connect("hostname","user","password") or die ("Couldn't connect to the server"); /*select database*/ $db = mysql_select_db("db_name", $connection) or die ("Couldn't select database"); /*execute query and get result*/ $sql_result = mysql_query($sql, $connection) or die ("Couldn't execute query1"); $sql_result1 = mysql_query($sql1, $connection) or die ("Couldn't execute query2");

                        if (!sql_result){
                        echo "<p>Couldn't add record!";
                        } else{

                        echo "
                        <p> Record Added!</p>
                        <table cellspacing=5 cellpadding=5>

/*More code down here...*/ _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com