To fetch information from several tables you usually use a join operation. Here's a starting point in the MySQL manual.
http://www.mysql.com/doc/en/JOIN.html
/Lars ([EMAIL PROTECTED])
Cesar Aracena wrote:
Hi all, I have several tables from which I have to fetch certain products & categories based on customer selection. The tables are as follows:Table 1 - Categories catid (autonum) catname Table 2 - Sub categories subcatid (autonum) subcatname Table 3 - Products prodid (autonum) prodname Table 4 - Relationships Catid Subcatid Prodid Now, the question is how to fetch all the sub-categories let's say that are related to category 0001. I know it's as simple as relating two tables in one query, but I don't remember how. Any help appreciated. Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
