James Tu wrote:
> (I've cross posted at the MySQL list as well)
>
> Here's an example with a simple table:
>
> describe collection;
>
> +------------------+---------------------+------+-----
> +---------------------+----------------+
>> Field | Type | Null | Key |
> Default | Extra |
> +------------------+---------------------+------+-----
> +---------------------+----------------+
>> id | bigint(20) unsigned | | PRI |
> NULL | auto_increment |
>> receiver_id | bigint(20) unsigned | | MUL |
> 0 | |
>> set_type_id | int(2) unsigned | | |
> 0 | |
>> card_id | int(3) unsigned | | |
> 0 | |
>> completed_set_id | bigint(20) unsigned | | |
> 0 | |
>> created_on_gmt | datetime | | | 0000-00-00
> 00:00:00 | |
> +------------------+---------------------+------+-----
> +---------------------+----------------+
>
>
> I want to end up with two PHP arrays. One for set_type_id = 22 and
> one for set_type_id=21.
>
> (1) one query method:
> SELECT * from collection WHERE set_type_id=22 OR set_type_id=21;
> ...do query... while( $row = $this->db->fetch_array_row() ){
> if ($row['set_type_id'] == 21){
> $array_a[] = $row;
> } else {
> $array_b[] = $row;
> }
> }
>
>
> (2) two query method:
> SELECT * from collection WHERE set_type_id=22;
> ...do query...
> while( $row = $this->db->fetch_array_row() ){
> $array_a[] = $row;
> }
>
> SELECT * from collection WHERE set_type_id=21;
> ...do query...
> while( $row = $this->db->fetch_array_row() ){
> $array_b[] = $row;
> }
>
>
> Which method is better? Take a hit using MySQL or take a hit using
> PHP?
>
> -James
I really don't think you'd notice any difference, unless your table contains
a large amount of data and is not properly indexed. And if that were the
case, you'd notice a hit on just one query anyway.
I'd stick with the 2 query model, but instead of creating arrays, just loop
through the query results to output your data, no sense looping to make an
array when you're just going to end up looping through the array to output;
that seems redundant to me :P
Just my $.02
-B
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
