how do I load from database into drop down menus?

mband2000

Ok the situation is kinda hard for me to explain...

I would like to make a drop down list that works as a jump menu! Meaning when it pulls from the database and places the info into the drop down list.. I can choose something and it sends me somewhere.. also I want the links to be a string.

For example..

this is a drop down list

-- State --
- Alabama
-Georgia
-New York

Now Alabama, Georgia, and Newyork are coming out of a row called state and in a table called users... now when I select Georgia.. I want the jumpbox to send me to ...

http//:www.mysite.com/directory/script.php?state=Georgia

^{^script.php} is the script that I was in when I selected Georgia.. so I know I need to send the script to it's self.

How can I do this?

twopeak

what do you mean by pull down menus?
if it's an option thing

search around between example code
you need to first connect to your db, then select the information you want with a mysql_query

once this is done, get all the information into an object (or an array if you prefere) with a while loop

and then it's a matter of logic thinking?
I'll just write some code, it will probably be full of syntax errors, but you'll get the picture

echo "<select name="USstates">";
$baseuri = "http://yourserver/yourscript.php?state=";
mysql_connect("host", "user", "pass");
mysql_select_table("tablename");
$content = mysql_query("SELECT name FROM cities");
while($list = mysql_fetch_object($content)){
$name = $list->name;
echo "<option value="$baseuri.$name">$name</option>";
}
</select>

and thenyou need to ask a submit button that takes the value out of USstates and goes to it, but that's javascript...

And sending a script to itself is really no problem... the script doesn't care where you came from...

mband2000

^thanks... but I still can't get my code to work...

Can anyone help! Or tell me what I'm doing wrong.

cgraz

Are you trying to pull info out of a field in your database and create a dynamic drop down list?

Or are you trying to get a drop down list with no input button so when someone selects the option, it takes them to a particular page without hitting a submit button?

Or do you want both of these combined?

Also when you say you can't get your code to work, say specifically what isn't working. It will be easier to help you this way.

Cgraz

mband2000

^{^I} want both of those combined... I need to pull data from the database to make the list within the dropdown menu.. then when an item from the menu is selected it takes them to the right place.

how can I do that?

cgraz

To create a dynamic drop down out of your database

<?

// Connect to MySQL Server
@mysql_connect($server, $username, $password) or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db($database) or DIE("Couldn't Select Database");

$result=mysql_query("SELECT your_field FROM $table");
$row_array=mysql_fetch_row($result);
$string='<select name=selection><option value=>Any Selection</option>';
for ($i=0;$i < mysql_num_rows($result);$i++)
{
	if ($row_array[0]=="")
	{
		$row_array=mysql_fetch_row($result);
	}
	else
	{
	$string .='<option value="'.$row_array[0].'">'.$row_array[0];
	$row_array=mysql_fetch_row($result);
	}
}
$string .='</SELECT>';
echo $string;
?>

You can select DISTINCT if you want. Like if you have two instances of John in the db, the dropdown would only display John once if you use DISTINCT.

Here's an example of how to do the redirect without the submit button.

<html>

<head>
<title></title>
<link rel="stylesheet" href="stylesheet/styles.css" type="text/css">
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}


//-->
</script>
</head>

<body>

<FORM>
<SELECT NAME="location" onChange="MM_jumpMenu('parent',this,0)">
    <font>
        <OPTION VALUE="page1.html">Page1</OPTION>
        <OPTION VALUE="page2.html">Page2</OPTION>
        <OPTION VALUE="page3.html">Page3</OPTION>           

    </SELECT>
</FORM>      

</body>

</html>

Cgraz