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