What would be more "appropriate" way to create a query:
Solution 1:
select records from registrants table
SELECT r.reg_id, r.date_registered, r.old_record
FROM registrants r
WHERE r.org_id=12
AND r.reg_status=0
AND r.reg_id=r.person_id
# php "validation"
if($old_record != 0)
{
SELECT CONCAT(people.last_name, ', ', people.first_name) FROM
people, registrants
WHERE people.instance_id=12
AND people.person_id=registrants.person_id
AND registrants.reg_id=r.ghost_record
}
this way 2nd query will be executed only if old_record is zero (let's
say 10% - 20% of all records)
Solution 2:
SELECT r.reg_id, r.date_registered, r.old_record, if(r.ghost_record!=0,
(SELECT CONCAT(people.last_name, ', ', people.first_name) FROM people,
registrants WHERE people.instance_id=12 and
people.person_id=registrants.person_id AND
registrants.reg_id=r.ghost_record), 'y') as registered_by_name
FROM registrants r
WHERE r.org_id=12
AND r.reg_status=0
AND r.reg_id=r.person_id
this way subquery will be executed "everytime", but I have everything on
one place?
thanks for any opinion...
afan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
