Reffering to an anchor (<a>) tag from the db

orensol

Hello,

I have a problem I am trying to solve, regarding anchors.

I have a database of articles, with the following structure:
tablename: article
fields: id, idheading, part, subpart, subpartheading, text.

id is the article id, idheading is the whole article heading, part is to detemine how much webpages should the article be divided into, subpart is to identify where to put an anchor tag, subpartheading is the sub-heading for this part, and text is the part's text.

Example for data:
1, "How to code PHP", 1, 1, "What is PHP?", "Text...."
1, "How to code PHP", 1, 2, "When did PHP Start?", "Text...."
1, "How to code PHP", 1, 3, "Before We Begin", "Text...."
1, "How to code PHP", 2, 1, "Coding Essentials", "Text...."
1, "How to code PHP", 2, 2, "Functions", "Text...."
.
.
.
etc.

Now, my problem is, that I want articles not to stretch too long down the browser, so I will divide them according to the field "part". However, I want each page to contain the whole table of contents, which I will build dynamically, according to "subpartheading". Now, the big question - how can I open a php generated page, and make the page jump to an anchor tag (let's say, the user clicks the heading "Functions", which is subpart 2 of part 2, while he is on part 1 of the article)? I have no problem generating a page with SELECT...WHERE part=2, but how do I make the page jump to the "Functions" section?

Thanks,
Oren

bastien

not sure if i get you right...does each page load one complete article (with all sub-parts) and you want that to have the jumps to the relevant sub-part

do you want to load only each part of the article (one sub-part per page) when the page is loaded?

orensol

Hey,

Well, Actually I kind of already have it figured out. I just echo an <a name="subpart".$subpart> tag before any subpartheading, and when I echo the content, at the top of the page, I echo before it <a href=articles.php?id=$id&part=$part#subpart.$subpart>. And then my articles.php uses the $_GET to determine which parts of the content to show (using the $id and $part). My purpose was to show each "part" on a different webpage, and to have each "subpart" available with an anchor through the table of contents (which I generate dynamically querying for each subpartheading with the corresponding article id number).

The neat thing is, that the browser even knows not to load the page again, when clicking a link when the only thing different about it is the hashmark (let's say, if I am on page articles.php?id=1&part=1, and then I click a link that its href is articles.php?id=1&part=1#subpart3, the page doesn't load again, it just jumps to the anchor. I thought it should load again, after all there should be a call to the php file, and have it preprocessed, but I didn't realize the browser does not request the file again if just the anchor is changed in the link).

Anyway, now I am facing another problem. I want to optimize the db structure. To put in an article now, means to put each subpart in a different row in the table. Which is good on the one hand, because then I don't have to put ANY html with the text, but it makes putting an article a tiring job... Inserting a 30 subparts article is copy&pasting 30 bulks of texts in different table rows... But if I, say, divide articles only to parts, and not to subparts, I will have less rows per article, and less job putting them in, but then I will have to put in also HTML in the text fields (like <p>, and the <a name=...>. I wouldn't be able to generate it dynamically.

Or would I? Any ideas?
Oren