RE: [PHP-DB] SELECT Statement
| From: | Jennifer Goodie | Date: | Wed, 09 Apr 2003 21:03:56 +0000 |
| Subject: | RE: [PHP-DB] SELECT Statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26966@lists.php.net to get a copy of this message | ||
That is a really poor solution, what if your table has 35 million rows? You
are much better off only pulling what you need. The previous answers that
refrence using the IN() operator are the way to go.
> -----Original Message-----
> From: Matthew Moldvan [mailto:mmoldvan@trilogyintl.com]
> Sent: Wednesday, April 09, 2003 1:16 PM
> To: 'shaun'; php-db@lists.php.net
> Subject: RE: [PHP-DB] SELECT Statement
>
>
> I would say SELECT * FROM table ... then loop through with PHP. WHERE is
> always optional, but usually needed/recommended.
>
> Regards,
> Matthew Moldvan
>
> System Administrator
> Trilogy International, Inc.
>
>
> -----Original Message-----
> From: shaun [mailto:shaun@mania.plus.com]
> Sent: Wednesday, April 09, 2003 4:12 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] SELECT Statement
>
>
> Hi,
>
> what is the best way to select rows with an unknown number rowIDs?
>
> e.g. SELECT * FROM TABLE WHERE Table_ID = '1', '2', '3'
>
> Thanks for your help
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>