[EMAIL PROTECTED] (Cesar Aracena) wrote in news:005801c2a3c6$8ac4f190
And the subcategories are related to categories with the Relationships
If that's the case:
SELECT * FROM Relationships WHERE CatId = '1'
And if you want the names.
SELECT * FROM Subcategories as sc, Relationships as r
WHERE r.CatId = 'minumber' and r.SubCatId = sc.subcatid
> 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)
> Table 2 - Sub categories
> subcatid (autonum)
> Table 3 - Products
> prodid (autonum)
> Table 4 - Relationships
> 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.
*** s2r - public key: (http://leeloo.mine.nu/s2r-gmx.sig)
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php