retrieve data from mysql

[Anon]

I need to add State specific data to a particluar webpage. I am setting up a mysql table which has each state as a record and fields containing the information for each state.

I want the student to first select his/her state from a dropdown box. Set the state as a variable and use the variable to retrieve the appropiate record and the information in a specific field.

This info should show up in a webpage that contains federal information and rebuild the page with the state info inserted along with the federal requirements

Any ideas about the coding to make this happen.

Capt Matt
http://boatsafe.com

[spider_man]

Ok, that should be done within two pages.
The first one, has a form pionting to the second one with a select combo.
This element could have the state id in the value and it's coresponding state name in the selection. eg.

// get al the states in $states

$states = mysql_query('select id, name from states');

echo '<form action="page2.php" method="post">';

echo '<select name="state_id">'

while ($row=mysql_fetch_array($states))
echo "<option value=\"$row[id]\">$row[name]\n";

echo '</select></form>';

Now onto the second page:

/ Get the info related with the corresponding state with id id number /

$info = mysql_query("select * from states where id=$state_id");

$row = msyql_fetch_array($info);
extract($row);

/ Now you've got each info in a variable with the same name of the table's column /

// There you go ;D