On Wed, Sep 14, 2011 at 4:12 AM, Dotan Cohen <dotancohen@xxxxxxxxx> wrote: > On Wed, Sep 14, 2011 at 06:05, chetan rane <chetan.d.rane@xxxxxxxxx> wrote: >> Hi, >> >> There are 2 peoblems with subselect >> >> 1. You cant use a limit on the nested select >> 2. Id the number of elements in the in clause exceeds the subselect buffer >> you will run into performance issues ans eventually you query will be >> doomed. Inner joins in,this is the best option for this . You can use a temp >> table for this >> > > Thanks Chetan. I will keep that in mind if I ever get around to > learning about subselects. > > Have a great day! > > -- > Dotan Cohen > > http://gibberish.co.il > http://what-is-what.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Just out of curiosity, where are these ids coming from? Doing a raw implode on them like that is a sql injection vuln. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
