[Resolved] select box

beach_nc

I have a select box, and I want to open a new page based on the selected row in the list. I can't seem to capture the value for the row selected.

Any suggestions would be appreciated.

<?php

$db = mysql_connect('host, 'username','password');

mysql_select_db('database',$db);

$result=mysql_query("SELECT * FROM providerinfo order by lastname,firstname");

echo "<select name=\"provider\">";

while ($row = mysql_fetch_array($result)) {
print "<option value=\"" . $row[0] . "\">" . $row[1] .", " . $row[2] . "</option>";

}

echo "</select>";

?>
<br>
<input type="submit" name="Submit" value="Select">

</form>

laserlight

The value would be in $_POST['provider']
if you want some sort of goto page based on the value of the selection menu, maybe JS would be a good alternative.

beach_nc

I still can't figure out where to put that code or how to display the information. Right now if I can get it to echo the $row[0] for the record I selected in the list box I will be happy. Once I have that I think I can put the rest of it together.

Here is what I have so far....

<html>

<body>

<?php

if(isset($_POST['submit'])) {

echo "xxxxxx";    //<--- the $row[0] for the record I selected in the list box

}
else{

// display form

<?php

$db = mysql_connect('localhost', 'username','password');
mysql_select_db('census',$db);
$result=mysql_query("SELECT * FROM providerinfo order by lastname,firstname");

echo "<select name=\"provider\">";

while ($row = mysql_fetch_array($result)) {
print "<option value=\"" . $row[0] . "\">" . $row[1] .", " . $row[2] . "</option>";

}

echo "</select>";

?>
<br>
<input type="submit" name="Submit" value="submit">
</select>
</form>

<?php

} // end if

laserlight

Please explain clearly what isnt working as expected.

beach_nc

It isn't a matter of what isn't working as expected, its a matter of not knowing how to do something.

I want to be able to click on an item in my select box, click the button, then either self post, or post to another page, using the information from the select box to pull a record from my db.

I have the posting piece down, and I can write the queries. I just don't know how to identify which record I selected from the select box.

stolzyboy

just like an input text field, it will be the variable of the name of the select box

will give you

$_POST['selector']

on the page you submit to

beach_nc

damn... Newbies forum how apropos for me to post on

stolzyboy

what???????

beach_nc

The answer was simple, a newbie question - it was appropriate I posted it on the newbie forum.