select form with while loop

[Anon]

<select name="cadsource_id">
<?php
$db = mysql_connect("localhost", "user", "passwd");
$result1 = mysql_db_query("cad_design_db",
"select cadsource_id, cadsource_name FROM cad_source order by cadsource_name");
while($row1 = mysql_fetch_object($result1)) {
echo "<option value=\"$row1->cadsource_id\"> $row1->cadsource_name </option>";
}
mysql_free_result($result1);

?>
</select>

prior to this snipit I have some code that I have a query to the database of assigned cadsource_id and cadsource_name and I would like to have that person selected in this pull down.

Can anyone point me in the direction on how they would do this?

Thanks

[Anon]

If I undestand this correctly you could place the following line before your while statement...

echo "<option selected value='$cadsource_id'>$cadsource_name</option>";

Assuming $cadsource_id and $cadsource_name have been assigned to the person selected.

-Paul

[rrijnders]

Well, assuming that you have assigned the user's cadsource_id to some variable like $user_cadsource_id, you could rewrite your while loop like this:

=================
while($row1 = mysql_fetch_object($result1)) {

echo "<option value=\"$row1->cadsource_id\" ";

if ($row1->cadsource_id == $user_cadsource_id) {
    echo "SELECTED";
}

echo "> $row1->cadsource_name </option>\n";

}

This will put the SELECTED attribute into the option of the previously selected user and that option will be the default selected option in your pull down.

HTH

-- Rich Rijnders
-- Irvine, CA US

[Anon]

try the following code snippet and check whether it helps u out.

<select name="cadsource_id">
<?php
$db = mysql_connect("localhost", "user", "passwd");
$result1 = mysql_db_query("cad_design_db",
"select cadsource_id, cadsource_name FROM cad_source order by cadsource_name");
while($row1 = mysql_fetch_object($result1)) {

/*** $priorcadsource_id should be the cadsource_id that u had queried from the database previously */

if($priorcadsource_id==$row1->cadsource_id)
{
	$selected=" selected";
}

echo "<option value=\"$row1->cadsource_id\" $selected> $row1->cadsource_name </option>";
}
mysql_free_result($result1);

?>
</select>

[Anon]

try the following code snippet and check whether it helps u out.
<select name="cadsource_id">
<?php
$db = mysql_connect("localhost", "user", "passwd");
$result1 = mysql_db_query("cad_design_db",
"select cadsource_id, cadsource_name FROM cad_source order by cadsource_name");
while($row1 = mysql_fetch_object($result1)) {

/*** $priorcadsource_id should be the cadsource_id that u had queried from the database previously */

if($priorcadsource_id==$row1->cadsource_id)
{
	$selected=" selected";
}

echo "<option value=\"$row1->cadsource_id\" $selected> $row1->cadsource_name </option>";
}
mysql_free_result($result1);

?>
</select>

[Anon]

Ignore my previous mail.

[Anon]

Thanks for the input guys. Pauls option would work if I want to have the selected entry twice. Which I would of been happy with so thanks to paul. But Richard and bibin had had a good idea. All I did differently was unset select after the echo.

here is what I ended up with:

<select name="cadsource_id">
<?php
$db = mysql_connect("localhost", "user", "password");
$result1 = mysql_db_query("cad_design_db",
"select cadsource_id, cadsource_name FROM cad_source order by cadsource_name");
while($row1 = mysql_fetch_object($result1)) {

if ($row[cadsource_id] == $row1->cadsource_id)
{
$selected="selected";
}
echo "<option value=\"$row1->cadsource_id\" $selected> $row1->cadsource_name </option>";
unset($selected);
}
mysql_free_result($result1);

?>
</select>

Thank guys!!