Fields from different tables
| From: | Dani Matielo | Date: | Sun, 11 May 2003 16:59:56 +0000 |
| Subject: | Fields from different tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27648@lists.php.net to get a copy of this message | ||
Ok, this problem is a little more complicate: I have 2 diferente tables, say
product and category. In product I have fields
id
name
id_category
and in category I have fields
id
name
Well, obviously, the field 'id_category' in product refers to the field 'id'
in the table category. Very well. Now I am making an array with my products
but instead of the field 'id_category' I would like the name of the category
to appear in the array...
How do I do that? :(
Dani
Who's still in PHP basics...
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003