Re: Thinking out loud - a continuation...
| From: | Jay Blanchard | Date: | Fri, 23 Mar 2012 19:37:52 +0000 |
| Subject: | Re: Thinking out loud - a continuation... | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-317234@lists.php.net to get a copy of this message | ||
[snip]
> Did you get any results form the database on the second run through the query loop?
[/snip]
Actually, no. I just ran the raw query -
SELECT DISTINCT
TIER3DATA AS id, TIER2DATA AS parentId FROM
POSITION_SETUP WHERE COMPANY_ID = '3' AND TIER2DATA
IN ('Executives and
Management','Professionals','Technicians','Craft
Workers-Skilled','Operatives','Contractor','Sales
Workers','Laborers and Helpers','Admin Support')
and it is empty.