On Wed, Sep 14, 2011 at 4:12 AM, Dotan Cohen <dotanco...@gmail.com> wrote:
> On Wed, Sep 14, 2011 at 06:05, chetan rane <chetan.d.r...@gmail.com> wrote:
>> 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
> 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