Jump to content

where clause is ambiguous


project3

Recommended Posts

Im having problems with a select statement.

I have a db table (ticket) with sid as on of the fields.

 

when I use WHERE `sid` = $id;

 

I get the error.

Column 'sid' in where clause is ambiguous

 

when I use WHERE `ticket.sid` = $id;

I get there error.

Unknown column 'ticket.sid' in 'where clause'

 

 

what am i doing wrong?

Link to comment
https://forums.phpfreaks.com/topic/89675-where-clause-is-ambiguous/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.