sorting via PHP or MySQL?
| From: | James Tu | Date: | Thu, 10 May 2007 18:00:21 +0000 |
| Subject: | sorting via PHP or MySQL? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254746@lists.php.net to get a copy of this message | ||
(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