Posted by Dave Nash on 12/09/06 20:47

Thanks Aho

So how do I get the data from a db.
I have retrieved the category listings with this

"SELECT * FROM categories" which gives me a page with the categories
and links to a a page called listitems.php

What I cant work out is how to view all of the items once i click on a
category that match the category id in the relational table.

thanks again.




On Sat, 09 Dec 2006 13:55:44 +0100, "J.O. Aho" <user@example.net>
wrote:

>Dave Nash wrote:
>> hi All,
>>
>> I have created a database with two tables, categories and items.
>>
>> How do I go about assigning a particular item to more than one
>> category?
>>
>>
>> <Categories table>
>> Catid
>> Catname
>>
>> <Items table>
>> Itemid
>> itemname
>
>Create a relation table
>
><ItemCat table>
>Itemid
>Catid
>
>
> //Aho

[Back to original message]