hi!
you can do it this way:
SELECT
product.id,
product.name,
category.name AS cat_name
FROM
product,
category
WHERE
category.id=product.id_category
hope this works?
.ma
Dani Matielo <dmatielo@uol.com.br> wrote@11.05.2003 18:59 Uhr:
> 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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
