Re: Querying a database for 50 users' information: 50 queries or a WHERE array?
| From: | Dotan Cohen | Date: | Tue, 13 Sep 2011 19:36:41 +0000 |
| Subject: | Re: Querying a database for 50 users' information: 50 queries or a WHERE array? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314811@lists.php.net to get a copy of this message | ||
On Tue, Sep 13, 2011 at 17:29, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote:
> SELECT * FROM table WHERE userID IN (1,2,3,4,5,etc)
>
> Much smaller than what you proposed in #3, and easier to make if your user is list is already
> an array.
>
Thank you Ash, that is exactly what I was looking for!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com