Dropdown Lists PHP - Writing Value To Procedure, Syntax Help

leonarmston

Hi there,

Trying to have a selectbox that queries the database which contains two fields countryID and countryName and outputs countryID. I can get it to work ok but not when I put

if($form->value("country") == "$row[countryID]"){ echo "selected"; }

which needs to be in to write the value to my procedures. If someone would be so kind to point me in the right direction and tell me what syntax mistake I am making it would be a great help.

Thanks very much

The code below works but I need to insert if($form->value("country") == "$row[countryID]"){ echo "selected"; } where it says HERE, what is the best way of doing this?


<?php
$p2=mysql_query("SELECT countries.countryID, countries.countryName FROM countries") or die(mysql_error());
echo "<select name=country>";
while($row=mysql_fetch_assoc($p2)) {
echo "<option value=$row[countryID]HERE>$row[countryName]</option>";
}
echo "</select>";
?>

My shocking attempt at it which I keep getting errors with.

 
<?php
$p2=mysql_query("SELECT countries.countryID, countries.countryName FROM countries") or die(mysql_error());
echo "<select name=country>";
while($row=mysql_fetch_assoc($p2)) {
echo "<option value=$row[countryID] {if($form->value("country") == "$row[countryID]"){ echo "selected"; }}>$row[countryName]</option>";
}
echo "</select>";
?>

bpat1434

where do you define the $form object?

Also.... just use this syntax in place of what you have:

".(($form->value('country')==$row['countryID'])?'selected':'')."

so this:

echo "<option value=$row[countryID] {if($form->value("country") == "$row[countryID]"){ echo "selected"; }}>$row[countryName]</option>";
}

becomes:

echo "<option value=$row[countryID] ".(($form->value('country')==$row['countryID'])?'selected':'').">$row[countryName]</option>";
}

leonarmston

Thanks that works a treat, using this login system at Here

$form is a function in database.php.

Just another problem but why is county and countries appearing at the top of form and not in the middle like the logical order of the form below.

<form action="process.php" method="POST">
<table align="left" border="0" cellspacing="0" cellpadding="3">

<tr><td>Username:</td><td><input type="text" name="user" maxlength="30" value="<? echo $form->value("user"); ?>"></td><td><? echo $form->error("user"); ?></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass" maxlength="30" value="<? echo $form->value("pass"); ?>"></td><td><? echo $form->error("pass"); ?></td></tr>
<tr><td>Confirm Password*:</td><td><input type="password" name="pass2" maxlength="50" value"<? echo $form->value("cPass"); ?>"></td></tr><? echo $form->error("cPass"); ?></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" maxlength="50" value="<? echo $form->value("email"); ?>"></td><td><? echo $form->error("email"); ?></td></tr>


<tr><td>Name:</td><td><input type="text" name="name" maxlength="100" value="<? echo $form->value("name"); ?>"></td><td><? echo $form->error("name"); ?></td></tr>
<tr><td>Address 1:</td><td><input type="text" name="address1" maxlength="150" value="<? echo $form->value("address1"); ?>"></td><td><? echo $form->error("address1"); ?></td></tr>
<tr><td>Address 2:</td><td><input type="text" name="address2" maxlength="150" value="<? echo $form->value("address2"); ?>"></td><td><? echo $form->error("address2"); ?></td></tr>
<tr><td>Town:</td><td><input type="text" name="town" maxlength="150" value="<? echo $form->value("town"); ?>"></td><td><? echo $form->error("town"); ?></td></tr>
<tr><td>Post Code:</td><td><input type="text" name="pCode" maxlength="150" value="<? echo $form->value("pCode"); ?>"></td><td><? echo $form->error("pCode"); ?></td></tr>

<?php
$p2=mysql_query("SELECT countries.countryID, countries.countryName FROM countries") or die(mysql_error());
echo "<select name=country>";
while($row=mysql_fetch_assoc($p2)) {
echo "<option value=$row[countryID]".(($form->value('country')==$row['countryID'])?'selected':'').">$row[countryName]</option>";
}
echo "</select>";
?>

<?php
$p3=mysql_query("SELECT counties.countyID, counties.countyName FROM counties") or die(mysql_error());
echo "<select name=country>";
while($row=mysql_fetch_assoc($p3)) {
echo "<option value=$row[countyID]".(($form->value('county')==$row['countyID'])?'selected':'').">$row[countyName]</option>";
}
echo "</select>";
?>

<tr><td>Telephone Number:</td><td><input type="text" name="teleNum" maxlength="150" value="<? echo $form->value("teleNum"); ?>"></td><td><? echo $form->error("teleNum"); ?></td></tr>

<tr><td colspan="2" align="right">
<input type="hidden" name="subjoin" value="1">
<input type="submit" value="Join!"></td></tr>
<tr><td colspan="2" align="left"><a href="main.php">Back to Main</a></td></tr>
</table>
</form>

leonarmston

Forget that sorry I hadnt included the lists in the table. Sorry :p