Gayner Posted October 9, 2009 Share Posted October 9, 2009 $DB->query("SELECT c.contact_name, c.contact_id, m.desktop, m.monkavatar FROM ibf_contacts c, ibf_members m WHERE member_id='".$member['id']."' AND c.contact_name=m.name ORDER By $rank LIMIT {$info['limitfriend']}"); am I calling all rows from the table "ibf_members" or just the specific ones? Cause i have alot of rows and Is there a more better performance way? Quote Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/ Share on other sites More sharing options...
Daniel0 Posted October 9, 2009 Share Posted October 9, 2009 No, you're not. You're both limiting the results using WHERE and LIMIT. I'm not sure I entirely understand your question though. Quote Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933967 Share on other sites More sharing options...
Gayner Posted October 9, 2009 Author Share Posted October 9, 2009 Like is that still calling all my rows in my table? or only the specific one's i chosen that have a c. before. ? Quote Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933975 Share on other sites More sharing options...
Daniel0 Posted October 9, 2009 Share Posted October 9, 2009 That depends on if you have indexes on the fields you are selecting by. Quote Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933986 Share on other sites More sharing options...
Gayner Posted October 10, 2009 Author Share Posted October 10, 2009 That depends on if you have indexes on the fields you are selecting by. U killed me right there Quote Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-934138 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.