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_
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
2 matches
Mail list logo
