[Resolved] Passing values to a list/menu

lee_umney

I am trying to pass a value to a list menu so that it will select the one in the database. i.e I have a page and in the database the section value = 'present' with the options being present and past, how would I do it so the list/menu displays the correct one automatically?

eriksmoen

if you only have one marked 'present' at a time, you can try:

$tmp = mysql_fetch_array(mysql_query("select FIELDNAME from TABLENAME where FIELDNAME = 'present'; "));
$result = $tmp[0];

otherwise, if you have multiple 'present's at a time, you can try:

$tmp = mysql_query("select FIELDNAME from TABLENAME where FIELDNAME = 'present'; ");
while($result = mysql_fetch_array($tmp)){
echo $result[0]."<BR>";
}

hope that helps

lee_umney

This is the code I have so far:-

<? echo"<select name=section size=1>
<option value=presrep>Present Repairs</option>
<option value=presstyle>Present Styling</option>
<option value=presrest>Present Restoration</option>
<option value=pastrep>Past Repairs</option>
<option value=paststyle>Past Styling</option>
<option value=pastrest>Past Restoration</option>
<option value='$section' selected>$section</option>
</select>"; ?>

I am redoing a site for a bodyshop, I did the orignal 'static' site but have an idea for making it dynamic.
When a vehicle's details are going to be edited I want it to preselect the current value, i.e.presstyle for present bodystyling.

MrCool

what eriksmoen said is what u gotta do:

while($result = mysql_fetch_array($tmp)){ 
echo "<option value='".$result['value']."'>".$result['name']."</option>";
}

And the you use a if condition to say whether it s selected or not

eriksmoen

I guess I'm not quite understanding what you are trying to do... if you want to keep appending things to your table, just use hidden fields to store the old data, then when user goes to the next form, pull all the hidden fields and throw them into the <select> tag.

otherwise, if you want to pull a list from a database or array and select the result of the current page, then simply do something like:

$array = new array( "pressrep😛resent Repairs","presstyle😛resent Styling", ...etc...);
$selected = (isset($POST['section']))? $POST['section'] : "";

echo "<select name='section'>";
foreach($array as $key => $value){
list($name,$title) = split($value);
$issel = ($selected == $name)? "selected" : "";
echo "<option name='$name' $issel>$title</option>";
}
echo "</select>";

hope that helps... if that's what you were looking for...

lee_umney

Thank you, I am picking this up quickly, I had the right thing, roughly but I'd forgot to get the correct value from the database.
Damn, I'm ugly and stupid.
Thank you once again guys.