Results 1 to 12 of 12
May 18, 2001, 02:48 #1
- Join Date
- Mar 2001
- the Netherlands
- 0 Post(s)
- 0 Thread(s)
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.