SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    .NET inside archigamer's Avatar
    Join Date
    Jan 2002
    Location
    Strongsville OH
    Posts
    1,534
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    putting something in multiple categories

    I am creating an online mall script using php and mysql. i need to have some things in multiple categories. the problem is i do not know how i can accomplish this can anyone give a suggestion.

    thanks in advance
    Web Finesse Studios
    Professional, business oriented web hosting and development.

  2. #2
    Are you ready for BSD? Marshall's Avatar
    Join Date
    Dec 2001
    Posts
    373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Create a separate table containing items associated with unique identifiers. Then use the unique identifier as a foreign key in other tables to refer back to the item.

    Of course, it would help if you told us more about your database structure and what exactly it is you're trying to accomplish.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •