database query

[tazgalsinh]

this is my query for my catalog:

SELECT *
FROM item, Manfac
WHERE item.ManID = Manfac.ManID
ORDER BY item.typeID

in the item table there is a typeID field. this field corepondes to a manfac table and in the table is the fields typeID and typeNAME. So in the item table, items with 2 as the typeID are software and 3 are tv's etc etc.

how am i able to pull of the typeNAME field staright into the catalog. so in my catalog list i have the correct typeNAME. can i one help please?

[Pig]

I read that sentence 3 times and I kept getting confused, but I think what your asking is just how to do a simple join.

Let me know if this doesn't answer your question:

items table: items
items_id
items_description
items_manufacturer_id
items_name

manufacturer table: manufacturer
manufacturer_id
manufacturer_name
manufacturer_address

The join looks like this:

$result = mysql_query("SELECT * FROM manufacturer, items WHERE  manufacturer_id=items_manufacturer_id AND items_id='1'");

//Then to access the data, you would do something like:
$row=msyql_fetch_assoc($result);

echo("We have a lovely $row[items_name] available, made by $row[manufacturer_name].");