[PHP] Help w/Error Message

2001-04-06 Thread Toni Barskile
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

Re: [PHP] Help w/Error Message

2001-04-06 Thread Joe Sheble (Wizaerd)
In your query you have compid specified twice. If this field is named the same in two seperate tables, preface your fieldnames with the table names... >$sql="SELECT fname, lname, users.compid, status, dept, room, bldg, phone, >ticket_num, tickets.compid, date_rpt, request_type, hardware, model

Re: [PHP] Help w/Error Message

2001-04-06 Thread Renze Munnik
Toni Barskile wrote: > > 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_