[Resolved] Pulling a value from pull down as a variable

PHP_apprentice

I have built a pull down that pulls from mysql for the value and the name of each option.

I would like to automatically fill in the correct company ID from the DB when the corresponding company name is selected from the pull down. I am pretty sure there is a simple way to do it. I would appreciate all the suggestions you may have.

stolzyboy

something like this should get you started

<option value="whateveridforcompany"<? if ($row['fieldfromdb'] == "whateveridforcompany") echo " selected"; ?>>

PHP_apprentice

Thanks for the response stolz, however what if the code I used looks like this and the value is a dynamic value from the DB:

while ($myrow = mysql_fetch_array($result)) {
printf("<option value=\"%s\">",$myrow["company_name"]);
printf("%s</option>",$myrow["company_name"]);
}

I am probably just to green at this to understand where my mistake is.

Thanks again for any help on this.

stolzyboy

so then you want another db-driven record set variable to check against that value?

PHP_apprentice

I may be way advanced in my thinking for my skill. That is correct I wanted to have the corresponding company id put in a text field on the page based on the company name selected from the pull down in real-time before actually submitting said form. This code is for a snippet library on a project I am working on so there is no actual form at this time.

stolzyboy

well then you could just modify what i had initially, but instead do

if valuefromcompanytable == valuefromrecordset echo selected

at any rate, you are merely doing an if condition on two different record sets, but in the option, you are echoing selected whether or not they match...

PHP_apprentice

Stolz, I know in my code that I am using the %S for the wildcard on the pull down option. What I don't know is what to use to pull that into my IF statement. This would actually answer a lot of questions for me.

stolzyboy

here is an example from one that i have done, what it does is gets the positions from the open position table with the first while loop, then inside that, there is a while loop finding all the titles from the position table and checks to see if the values match, if they do, then echo selected, that part is in the if

<?
$query1 = "select * from open_position where id = '$id';";
$result1 = mysql_query($query1) or die(mysql_error());

while ($row1 = mysql_fetch_array($result1))
{
?>
Title:<br>
<select name="title" class="text1">
<?
$queryp = "select * from position order by title;";
$resultp = mysql_query($queryp) or die(mysql_error());

while ($rowp = mysql_fetch_array($resultp))
{
?>
<option value="<? echo $rowp['title']; ?>"<? if ($row1['title'] == $rowp['title']) echo " selected"; ?>><? echo $rowp['title']; ?></option>
<?
}
}
?>