spdwrench Posted September 5, 2007 Share Posted September 5, 2007 the following code has the original query and the updated query that locks up the server... is there a problem with my syntax in the second one that is commented out? $search_query = "SELECT p.id, p.gender, p.name, p.general_info, m.age, f.filename_1 FROM (dt_profile p, dt_photos f, dt_members m, dt_privacy pr) WHERE (p.status='1' AND (pr.featured_yn IS NULL OR pr.featured_yn='') AND pr.member_id=m.id AND p.member_id=m.id AND f.member_id=m.id AND f.filename_1<>'' AND p.gender='$genders[name]') "; //$search_query = "SELECT p.id, p.gender, f.filename_1 FROM (dt_profile p, dt_photos f) WHERE (p.status='1' AND f.filename_1<>'' AND p.gender='$genders[name]') "; Quote Link to comment https://forums.phpfreaks.com/topic/68078-is-my-syntax-ok-server-jamming-up-when-i-run-this-querry/ Share on other sites More sharing options...
btherl Posted September 6, 2007 Share Posted September 6, 2007 It looks like you are joining dt_profile and dt_photos without a join condition in the second query. Quote Link to comment https://forums.phpfreaks.com/topic/68078-is-my-syntax-ok-server-jamming-up-when-i-run-this-querry/#findComment-342548 Share on other sites More sharing options...
fenway Posted September 7, 2007 Share Posted September 7, 2007 And an EXPLAIN will show that... Quote Link to comment https://forums.phpfreaks.com/topic/68078-is-my-syntax-ok-server-jamming-up-when-i-run-this-querry/#findComment-343925 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.