php parameters href= name=

[gsmackay]

With standard html I can add a link using tags (href=#link1) to jump down the page. How do I create those links when the page has parameters that are used in a mysql query? I tried www.example.com?parm1=val1&parm2=val2#link1 but that did not work. The query is needed to generate the page on the fly, I then want to create a 'menu' across the top that jumps down to various parts of the page.

• Gary

[trex005]

okay... if I am hearing you correctly, you need to dynamically make
<A HREF='#section1'>Section 1</A>
and
<A NAME='section1'></A>
Tags....

and I'm assuming that the issue is that you echo the "contence" at the top and then loop through the query and place the output.
IF this is the case, what you might want to consider is not echoing untill the very end.. let me try to give you an example...

<?
// the following info junk is an attempt to emulate MySQL output
$info[0] = array('section_id' => '1', 'title'  => 'Section 1' , 'content' => 'this is section 1');
$info[1] = array('section_id' => '2', 'title'  => 'Section 2' , 'content' => 'this is section 2');
$info[2] = array('section_id' => '3', 'title'  => 'Section 3' , 'content' => 'this is section 3');
$info[3] = array('section_id' => '4', 'title'  => 'Section 4' , 'content' => 'this is section 4');
$info[4] = array('section_id' => '5', 'title'  => 'Section 5' , 'content' => 'this is section 5');
$info[5] = array('section_id' => '6', 'title'  => 'Section 6' , 'content' => 'this is section 6');
$info[6] = array('section_id' => '7', 'title'  => 'Section 7' , 'content' => 'this is section 7');
$info[7] = array('section_id' => '8', 'title'  => 'Section 8' , 'content' => 'this is section 8');
$info[8] = array('section_id' => '9', 'title'  => 'Section 9' , 'content' => 'this is section 9');
$info[9] = array('section_id' => '10', 'title'  => 'Section 10' , 'content' => 'this is section 10');
$info[10] = array('section_id' => '111', 'title'  => 'Section 11' , 'content' => 'this is section 11');
// End attempt to emulate MySQL output
$toc = "<A NAME=0></A>";
$content = "";
foreach($info as $row)
{
	$toc .= "<A HREF='#" . $row['section_id'] . "'>" . $row['title'] . "</A><BR>";
	$content .= "<A NAME='" . $row['section_id'] . "'></A><B>" . $row['title'] . "&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=-2><A HREF='#0'>Back To Top</A></FONT><BR>" . $row['content'] . "<BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>";
}

echo $toc,$content;

?>

[gsmackay]

Thanks! Turns out the real problem was I was placing a '#' where I should not have been in the link. But I like your idea of only looping through the results once. Now I'm looping through the sql records twice, once to build the top menu, then again to actually display the data. The only question I have is regarding memory consumption by placing a whole page of info in a variable. Any red flags there?

Thanks again,
- Gary

[trex005]

well, one could argue that if you have output buffering on, you are doing the exact same thing. I must admit however that I have the luxury of working on my own dedicated fairly beefy server... and only maybe having about a hundred users at any given time, and my limitations are usually processor not memory...