php and jumpboxes

[__greg]

im trying to figure out how to have a selection jumpbox thing load with a different value depending what was previously entered. here's what im working on:

<tr>
    <td valign='middle' align='right'><b>Release Date:</b></td>
    <td>
	<select name='rev_month' class='box1'>
	  <option selected id=". $row["rev_month"] ."></option>
      <option value=1>January</option>
      <option value=2>February</option>
      <option value=3>March</option>
      <option value=4>April</option>
      <option value=5>May</option>
      <option value=6>June</option>
      <option value=7>July</option>
      <option value=8>August</option>
      <option value=9>September</option>
      <option value=10>October</option>
      <option value=11>November</option>
      <option value=12>December</option>
    </select>

it's not working, but what im trying to do is if, say April (option 4) was selected when i put this info into the database, i want the jumpbox to load up with april selected. know what im saying? if anyone could help i would really appreciate it. thanks.

[mogster]

You must post some of the code, so that we know what format you store the month as, and what you are after 😉

knutm

[__greg]

table: reviews

if (mysql_query("INSERT INTO reviews (rev_artist, rev_firstname, rev_title, rev_label, rev_month, rev_day, rev_year, rev_rating, rev_url, rev_author, rev_email, rev_body, rev_cover)          

				 VALUES ('" . addslashes($HTTP_POST_VARS["rev_artist"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_firstname"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_title"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_label"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_month"])  .
				"', '" . addslashes($HTTP_POST_VARS["rev_day"])  .
				"', '" . addslashes($HTTP_POST_VARS["rev_year"])  .
				"', '" . addslashes($HTTP_POST_VARS["rev_rating"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_url"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_author"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_email"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_body"]) .
				"', '" . addslashes($HTTP_POST_VARS["rev_cover"]) .

				"');") )

and this is some of the form:

<select name="rev_month" class="box1">
      <option value="1">January</option>
      <option value="2">February</option>
      <option value="3">March</option>
      <option value="4">April</option>
      <option value="5">May</option>
      <option value="6">June</option>
      <option value="7">July</option>
      <option value="8">August</option>
      <option value="9">September</option>
      <option value="10">October</option>
      <option value="11">November</option>
      <option value="12">December</option>
    </select>

when you press the submit button. it puts this into the database lastlifemedia_com and the table reviews.
thanks

[mogster]

Well, I guess your month in db is in the format 1, 2, 3 and so on:
You need to print out the monts by php, and I assume that the return of your actual month is in the value of $dMonth:

$mArr = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12);
$mArrstring = array(January, February, March, April, May, June, July, August, September, October, November, December);
echo "<select name=\"rev_month\" class=\"box1\">"
$i=0;
for($i=0;$i<sizeof($mArr);$i++) {
if($mArr[$i] == $dMonth) {
echo "<option value=\"$mArr[$i]\" selected>$mArrstring[$i]</option>";
} else {
echo "<option value=\"$mArr[$i]\">$mArrstring[$i]</option>";
}
}
echo "</select>";

Maybe you have to play around with the loop-length, but at least this gives you something to work with 😉
I can't seem to think straight today.

Later:
It is now edited slightly, and tested: it works!
http://boomdesign.no/odd_stuff/select_honky.php?dMonth=2

knutm 😃