Jump Menu Problem

[mdub2112]

Hiya All

I have a page that basically provides links to downloads grouped by the file's client name (company name). Now each section on the page has a named anchor that's populated with that client's name

echo '<h3><a name="'.$nameOf['company'].'"></a>'.$nameOf['company'].'</h3>';

Now, I'm trying to create a jump menu that will uhhh jump...to each anchor when selected.

The code I've been trying to use is:

		$anchor_qry = "select code, company from clients c, project_mgr_permissions mp 
		where c.code = mp.client and mp.username = '{$_SESSION['auth_user']}'";
		$anchor_result = $handle->query($anchor_qry);
		while ($anchor = $anchor_result->fetch_assoc())
			{
			?>
			<form name="jump1">
			<select name="jump" onChange="MM_jumpMenu('parent',this,0)">
			<?php echo "<option value=index.php#".$anchor.">".$anchor."</option>"; ?>
			</select></form>
			<?php
			}

The problem is, my results end up showing as five separate drop down boxes (there's only 5 client names entered in the dbase for testing) with the word "Array" in it.

Any help definitely appreciated.

[bradgrafelman]

That's because $anchor is an associative array with the column names as keys.

You select two columns in your query... which column is supposed to go where? is "code" supposed to be in the URL, and "company" between the OPTION tags? If so, you'd do something like..

<?php echo "<option value=index.php#".$anchor['code'].">".$anchor['company']."</option>"; ?>

Looks like you need to visit the manual page for [man]mysqli_fetch_assoc[/man] and see how this function works.

[ClarkF1]

It's creating a separate form for each result.

This should work

$anchor_qry = "select code, company from clients c, project_mgr_permissions mp
        where c.code = mp.client and mp.username = '{$_SESSION['auth_user']}'";
        $anchor_result = $handle->query($anchor_qry);
?>
<form name="jump1">
<select name="jump" onChange="MM_jumpMenu('parent',this,0)">
<?php        

while ($anchor = $anchor_result->fetch_assoc())
            {
            ?>

        <?php echo "<option value=index.php#".$anchor['code'].">".$anchor['company']."</option>"; 
        }
?></select></form>