Lijoyx Posted October 9, 2007 Share Posted October 9, 2007 hai welcome, whats wrong with the code the code works when i replace in with LIKE SELECT custumerlogin.cus_fname, general.ge_city FROM general, custumerlogin WHERE general.ge_id = custumerlogin.cus_id AND custumerlogin.cus_fname IN ('lijdy','git') LIMIT 0 , 30 Quote Link to comment Share on other sites More sharing options...
fenway Posted October 9, 2007 Share Posted October 9, 2007 There's nothing wrong with that code... but it shouldn't work with LIKE... that's not interchangable with IN. Quote Link to comment Share on other sites More sharing options...
bri0987 Posted October 16, 2007 Share Posted October 16, 2007 I would say this just to be clear... SELECT custumerlogin.cus_fname, general.ge_city FROM general, custumerlogin WHERE general.ge_id = custumerlogin.cus_id AND general.ge_id = custumerlogin.cus_fname IN ('lijdy','git') LIMIT 0 , 30 The AND does not seem to be pointed equal to anything... I hope that helped I'm new at this but I think it will. Let me know. Quote Link to comment 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.