[Resolved] pre-populate form select with db info

chriswheat

Hello,

I have a db table called zipcodes and with in that table I have a field called zipcode

I want to prepopulate the options in a form "select"

<select size="1" name="zipcodes">
<option>info from db</option>
<option>info from db</option>
<option>info from db</option>
<option>info from db</option>
<option>and so on</option>
</select>

I know how to connect to the db and I know I would start with
SELECT Zipcode FROM Zipcodes

after this I am lost

Thanks
Chris

LordShryku

Okie...

/*
  assuming you're connected
  and have chosen the DB
*/

$sql = mysql_query("SELECT Zipcode FROM Zipcodes");
if(mysql_num_rows($sql) > 0) {
   // If there are rows, make the select box
   echo "<select name=\"zipcodes\">";

   while($row=mysql_fetch_array($sql)) {
      echo "<option value=\"".$row['Zipcode']."\">".$row['Zipcode']."</option>";
   }
   echo "</select>";
}

chriswheat

Thank yOu!

I just noticed that their are 46373 zip codes in the data base and loading all of them in a select would be a bad idea

lets say i have a form and they can input the zipcode into a varuable $proposedzip

how would I take $proposedzip and make sure it is in the zipcode field?

LordShryku

Well, once the form is submitted, you can run a sql query to check against it

$sql = mysql_query("SELECT * FROM Zipcodes WHERE Zipcode = '".$_POST['proposedzip']."'"); 
if(mysql_num_rows($sql) > 0) { 
   // it exists
}
else {
   // it doesn't
}