ramli Posted January 30, 2009 Share Posted January 30, 2009 I have a problem with my database structuere, and i am not sure how to resolve it. I have two tables. Users Username Password Role | | | | | Client_data Client_ID Username Location Zipcode Execute the following qurey SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username Workes fine but when i like to search on username i get a error SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username WHERE Username LIKE '%$search%' Error: #1052 - Column 'username' in field list is ambiguous I know it is a problem coused by the colomn username only i don't know wat to do to resolve it, can anyone help me pleace ? Thx in advance Quote Link to comment https://forums.phpfreaks.com/topic/143122-solved-join-error-dubble-keys/ Share on other sites More sharing options...
rhodesa Posted January 30, 2009 Share Posted January 30, 2009 you have to specify the table: SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username WHERE Users.Username LIKE '%$search%' Quote Link to comment https://forums.phpfreaks.com/topic/143122-solved-join-error-dubble-keys/#findComment-750610 Share on other sites More sharing options...
ramli Posted January 30, 2009 Author Share Posted January 30, 2009 yep it solved my problem.... thanks Quote Link to comment https://forums.phpfreaks.com/topic/143122-solved-join-error-dubble-keys/#findComment-750702 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.