Thanks Marek, That put me right on track :)
Justin
on 23/01/03 11:24 PM, Marek Kilimajer ([EMAIL PROTECTED]) wrote:
> SELECT * FROM partner p LEFT JOIN pid_to_sid p2s ON p.id=p2s.pid LEFT
> JOIN service s ON p2s.sid=s.id LEFT JOIN category c ON s.categoryid=c.id
> WHERE $your_conditions ORDER
For me it seems it can be done with one mysql query:
SELECT * FROM partner p LEFT JOIN pid_to_sid p2s ON p.id=p2s.pid LEFT
JOIN service s ON p2s.sid=s.id LEFT JOIN category c ON s.categoryid=c.id
WHERE $your_conditions ORDER BY p.name, c.name, s.name
The important part is ORDER BY clause, so whe
// pseudo code (mostly)
if (mysql_query("SELECT * FROM partner, category, service
WHERE partner.id = service.id
AND service.categoryid = category.id"))
{while ($array = mysql_fetcharray($result))
{$partners[$array["id"][]= $array;
}
}
// then do ...
3 matches
Mail list logo
