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]') "; 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. 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... 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
Archived
This topic is now archived and is closed to further replies.