[PHP] Re: Error message

Thanks for everyone's help w/the error message thing. I got my SQL statement working, but it's not returning any rows. I noticed that there's nothing in my compid field in the 2nd table. Does anyone know how I might go about automatically filling in the value in the 2nd table when someone en

[PHP] Help w/Error Message

Hi: Can someone please explain the following error message? ERROR 1052: Column: 'compid' in field list is ambiguous Here's my mySQL statement: $sql="SELECT fname, lname, compid, status, dept, room, bldg, phone, ticket_num, compid, date_rpt, request_type, hardware, model, dci, dci_num,software

[PHP] 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 s