Select Box Problem

ccooper

I'm pulling in a list of states and state codes in a drop down menu. I want to call in the previously selected state, if an entry needs to be updated.

Here's my code for the array.

<? function getstatecode()
{ $statecode = array(1=>
"AL" ,
"AK" ,
(All other state codes here)
"WY" );
return $statecode;
}

function getstatename()
{
$statename = array(1=>
"Alabama",
"Alaska",
(all other states here)
"Wyoming" );
return $statename;
}
?>

Here's the code I'm calling it in with on my edit page. "state" is the name used in my database for for the two letter state codes.

<select name="state">

<?php
$statename=getstatename();

$statecode=getstatecode();

for ($n=1;$n<=50;$n++)

{
$states=$statename[$n];
$scode=$statecode[$n];
echo "<option value='$scode'";
if ($scode== $state)
echo "selected";
echo ">$states\n";
}
?>
</select>

It won't, no matter how much I slap it around, echo the selected box.

All help is thanked for in advance.

theslinky

Firstly, you need a space before the "selected":

if($scode == $state) {
echo " selected";
}

secondly, if the above still doesn't solve the problem, have you tried printing out the values of $scode and $state concurrently to see if they are the same?

perhaps an additional characters like a newline (\n) or space ( ) is present in $state. In that case, use a rtrim(). another way to do it is to use ereg:

if(eregi('$scode', $state)) {
echo " selected";
}

-sridhar

ccooper

O.k. I've got a new approach and I'll be danged if works as badly as the one posted above.

WHY DOESN'T THIS WORK!

It will post to my database, everything works great....but it will not echo SELECTED!

<tr>
<td valign="top" class="text"><b>State:</b></td>
<td class="text">
<select name="state">
<option value="AL"<? if ($state == "AL") echo "SELECTED"?>>Alabama
<option value="AK"<? if ($state == "AK") echo "SELECTED"?>>Alaska
<option value="TN"<? if ($state == "TN") echo "SELECTED"?>>Tennessee
</select>
</td>
</tr>

HERE IS THE FULL PAGE CODE FROM MY ADMIN AREA.

<?
// includes
include("conf.php");
include("functions.php");

// form not yet submitted
// display initial form with values pre-filled
if (!$submit)
{
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT id, date_year, date_month, date_day, city, state, venue, venue_web, bill, bill_web, show_info FROM $dbtable WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// if a result is returned
if (mysql_num_rows($result) > 0)
{
	// turn it into an object
	$row = mysql_fetch_object($result);

	// print form with values pre-filled

?>
<table cellspacing="0" cellpadding="5" border="0" align="center">
<tr>
<td colspan="2" align="center" class="text">Remember to always update DATE
and STATE drop down menus.</td>
</tr>
<form action="<? echo $PHP_SELF; ?>" method="POST">
<input type="hidden" name="id" value="<? echo $id; ?>">
<tr>
<td valign="top" class="text"><b>Date:</b></td>
<td class="text">
<?php

/ create an array of months/
$monthName = array(1=> "January", "February", "March", "April",
"May", "June", "July", "August",
"September", "October", "November",
"December");

$today = Time(); //stores today's date
$f_today = date("M-d-Y",$today); //formats today's date

/ build selection list for the month /
$todayMO = date("m",$today); //get the month from $today
echo "<select name='date_month'>\n";
for ($n=1;$n<=12;$n++)
{
echo "<option value=$n\n";
if ($todayMO == $n)
{
echo " selected";
}
echo "> $monthName[$n]\n";
}
echo "</select>";

/ build selection list for the day /
$todayDay= date("d",$today); //get the day from $today
echo "<select name='date_day'>\n";
for ($n=1;$n<=31;$n++)

{
echo " <option value=$n";
if ($todayDay == $n )
{
echo " selected";
}
echo "> $n\n";
}
echo "</select>\n";

/ build selection list for the year /
$startYr = date("Y", $today); //get the year from $today
echo "<select name='date_year'>\n";
for ($n=$startYr;$n<=$startYr+1;$n++)
{
echo " <option value=$n";
if ($startYr == $n )
{
echo " selected";
}
echo "> $n\n";
}
echo "</select>\n";
?>
</td>
</tr>
<tr>
<td valign="top" class="text"><b>City:</b></td>
<td class="text">
<input type="text" name="city" size="30" value="<? echo $row->city; ?>">
</td>
</tr>
<tr>
<td valign="top" class="text"><b>State:</b></td>
<td class="text">
<select name="state">
<option value="AL"<? if ($state == "AL") echo "SELECTED"?>>Alabama
<option value="AK"<? if ($state == "AK") echo "SELECTED"?>>Alaska
<option value="TN"<? if ($state == "TN") echo "SELECTED"?>>Tennessee
</select>
</td>
</tr>
<tr>
<td valign="top" class="text"><b>Venue:</b></td>
<td class="text">
<input type="text" name="venue" size="30" value="<? echo $row->venue; ?>">
</td>
</tr>
<tr>
<td valign="top" class="text"><b>Venue <br>
Website</b></td>
<td class="text">
<input type="text" name="venue_web" size="30" value="<? echo $row->venue_web; ?>">
</td>
</tr>
<tr>
<td valign="top" class="text"><b>Also Playing:</b></td>
<td class="text">
<input type="text" name="bill" size="30" value="<? echo $row->bill; ?>">
</td>
</tr>
<tr>
<td valign="top" class="text"><b>Also Playing <br>
Website:</b></td>
<td class="text">
<input type="text" name="bill_web" size="30" value="<? echo $row->bill_web; ?>">
</td>
</tr>
<tr>
<td valign="top" class="text"><b>Show Information:</b></td>
<td class="text">
<textarea name="show_info" cols="30" rows="6"><? echo $row->show_info; ?></textarea>
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="Submit" name="submit" value="Submit Information">
</td>
</tr>
</form>
</table>
<?
}
// no result returned
// print graceful error message
else
{
echo "Text not found.";
}
}
// form submitted
// start processing it
else
{
// set up error list array
$errorList = array();
$count = 0;

// validate text input fields
if (!$city) { $errorList[$count] = "Please enter a City."; $count++; }

if (!$venue) { $errorList[$count] = "Please enter Main City."; $count++; }

// set default value for contact person
if (!$contact) { $contact = $def_contact; }

// check for errors
// if none found...
if (sizeof($errorList) == 0)
{
	// open database connection
	$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

	// select database
	mysql_select_db($db) or die ("Unable to select database!");

	// generate and execute query
	$query = "UPDATE $dbtable SET date_year='$date_year', date_month='$date_month', date_day='$date_day',city='$city',state='$state',venue='$venue', venue_web='$venue_web',bill='$bill',bill_web='$bill_web',show_info='$show_info' WHERE id=$id";
	$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

	// print result
	echo "<table width=780 align=center><tr><td align=center class=text><b>Update Complete. <a href=list.php> Click here to return to Tour Dates.</a></b></td></tr></table>.";

	// close database connection
	mysql_close($connection);
}
else
{
	// errors occurred
	// print as list
	echo "<font size=-1>The following errors were encountered: <br>";
	echo "<ul>";
	for ($x=0; $x<sizeof($errorList); $x++)
	{
		echo "<li>$errorList[$x]";
	}
	echo "</ul></font>";
}

}
?>
</body>
</html>