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 Link to comment https://forums.phpfreaks.com/topic/72453-solved-why-its-not-working/ 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. Link to comment https://forums.phpfreaks.com/topic/72453-solved-why-its-not-working/#findComment-365466 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. Link to comment https://forums.phpfreaks.com/topic/72453-solved-why-its-not-working/#findComment-370363 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.