Can't think of a solution!!

[snowangel]

Hi!
I've got a problem, and I just can't think of a solution... I know the answer is right there before my very nose, and I know it can be done in PHP... but how?
Okay, look at this site (I think it's Italian, but it could be Spanish, too, so no idea):
http://halliwellsisters.com/serie/guia/209.php

There you see an episode of Charmed, and on the left side every category for which information is provided (I think the first one is "general information", and one means something like "demons", and so on). If you click on it, you see the information on the right side.

Okay, I'd like to do the same, but with one difference: I also have a separate "general information" and "demons" section on my side (it's not a Charmed site, these are just examples) where everything is, again, sorted into episodes etc.

How can I manage that I only have to upload the information (for example "demons" for the episode 2.13 etc.) once, and that it's displayed both in the episodes section on the left side (as a link), and in the "demons" section for that episode?

Okay I know that this is kinda complicated, but is there any way to do that? Just give me a hint and I'll try to do it myself! And yes, I know includes and let's say I'm familiar with the basics of PHP... but I just can't figure it out I can manage a page like that one, but how can I get the information to also show in the separate section (for example "demons")?

Thanks in advance if you can help!!

[sypher]

You need to explain it a little clearer. Because ive got no idea what your on about :P

[snowangel]

Okay, sorry... I'm not much of an explaining person

Okay let's stay Charmed. Let's say I have got a "Book of Shadows" page on my site, where all spells of all episodes are listed, divided into seasons which are divided into episodes. You click on a season and then choose the episode number, and then all spells used in that episode are displayed.
I can do that, no problem.

But let's say I also have an "Episodes" section, just like the one from the link, where you also choose a season and then an episode, and then you have the site from the link.

So when I upload the spells for an episode to the "Book of Shadows" section, I would have to manually edit the link in the "Episodes" section to point to the page with the spells just uploaded.

So what I need is kind of a cross-linking solution. When I, for example, upload all the actors starring in that episode, I need the "actors" section updated at the same time. Let's say Actor X is starring in episode 5.11, and I upload the information that Actor X is starring in that episode, that the page of episode 5.11 AND the page of Actor X are updated at the same time.

Uhm... I don't know how to explain it better, sorry! If you have questions, I'll try to give better answers

Thanks for trying to help!!

[sypher]

Then you would need an extra query function to enter the values into the other table.

Example:
You add a new episode and list the actors in fields plus any other info.
Then you would use the episode number and actors for your 'actors to episodes' table and add this info as part of your add_episode.php

So it would automatically do the function whilst adding the episode.