SitePoint Sponsor

User Tag List

Results 1 to 12 of 12

Threaded View

  1. #1
    SitePoint Evangelist jazztie's Avatar
    Join Date
    Mar 2001
    Location
    the Netherlands
    Posts
    519
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well...
    I have a new marvelous problem.

    I have two tables

    rubrieken (id, title) and
    pages (id, txt, rubrieken)
    pages.rubrieken is a foreign key to rubrieken.id

    Now the fun part starts...
    pages.rubrieken can have zero, one or more rubrieken.
    for instance; '1,23,48' (this also the way it is stored in the database)

    Now, when I delete an entry in table rubrieken
    ("DELETE FROM rubrieken WHERE id='$id'")
    I also want that particular rubrieken.id removed from pages.rubrieken. But only that particular one... not the others.

    so for instance... when I remove rubrieken.id '23' the pages.rubrieken would read; '1,48'

    Could someone help me with this problem? I don't know how to tackle this problem...
    Last edited by jazztie; May 18, 2001 at 02:53.


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
  •