Multiple 'similar' dropdowns -> 1 query

[frizzle]

Hi there

I'm building this CMS, and at a point i have
3 similar drop downs. The values of the drop
downs are called from a MysqlDB.

The first one is just fine:
do{

$selected = ($_GET['id_1'] == $result['id']) ? ' selected' : '';

echo '<option'.$selected.'>'.$result['id'].'</option>';

}while($result = mysql_fetch_array($query));
If the value of $_GET['id_1'] matches a value from the DB,
that value is selected in the final dropdown.

But when i try to do it again with $_GET[id_2] or $_GET[id_3], it
fails.
How can i 'recall' the mysql info?

Thanks.

Frizzle.

[Geoff Berrow]

I noticed that Message-ID:
<11*********************@g49g2000cwa.googlegroups. com> from frizzle
contained the following:

But when i try to do it again with $_GET[id_2] or $_GET[id_3], it
fails.
How can i 'recall' the mysql info?

I usually create an array of the db info then create the from that. All
you need to do then is check if $_GET[id_n] is in the array.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[frizzle]

Hmm, could you maybe explain a little bit more?
I'm not trying to find a better way for the '$selected'-part,
but i'm not able (yet) to create the same dropdown three
times from 1 query ...

Thanks.

Frizzle.

[Geoff Berrow]

I noticed that Message-ID:
<11**********************@g43g2000cwa.googlegroups .com> from frizzle
contained the following:

Hmm, could you maybe explain a little bit more?
I'm not trying to find a better way for the '$selected'-part,
but i'm not able (yet) to create the same dropdown three
times from 1 query ...

If you are doing something more than once you need to be thinking
'function'
Let is say you query the database and do a loop to put the values in an
array. In the following function, $name is the name of the select box,
$array is the array from the database and $sel is the selection you are
testing.

function mk_select($name,$array,$sel){
$string = "<select name=\"$name\"class=\"input\">";
foreach ($array AS $key=>$value) {
if($key==$sel){$selected=" selected";}
else{$selected="";}
$string .= "<option
value=\"$key\"$selected>$value</option>\n";
}
$string.="</select>";
return $string;
}
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[frizzle]

Hmm, being the newbie i am, i still can't get it to work:
i have $result = mysql_fetch_array($get_result);

Works fine with a

do{
foo
}while($result = mysql_fetch_array($get_result));

It returns the following from the DB:

id code
____________
27 ABC becomes: <option value="27">ABC</option>
35 KNO becomes: <option value="35">KNO</option>
57 TRE etc.
81 FLO etc.
____________

But when i call your function like this:
echo mk_select('name_1', $result, 'find_this');
it returns 4 items wich is correct, but the first two
are one id, and the third and fourth are a code.

Something like this:
id code
____________
<option value="">27</option>
<option value="">27</option>
<option value="">KNO</option>
<option value="">KNO</option>
____________

i just can't figure it out ...

Greetings Frizzle.

[Geoff Berrow]

I noticed that Message-ID:
<11*********************@g43g2000cwa.googlegroups. com> from frizzle
contained the following:

Hmm, being the newbie i am, i still can't get it to work:
i have $result = mysql_fetch_array($get_result);

Works fine with a

do{
foo
}while($result = mysql_fetch_array($get_result));

It returns the following from the DB:

id code
____________
27 ABC becomes: <option value="27">ABC</option>
35 KNO becomes: <option value="35">KNO</option>
57 TRE etc.
81 FLO etc.
____________

So $result[id] ==27 $result[code]==ABC

You have to combine those into a new array
$select_array=array();
while($result = mysql_fetch_array($get_result)){
$select_array[$result[id]]=$result[code];
}

Then your new array will contain the database rows as key/value pairs
and you can use it in the function.

echo mk_select('name_1', $select_array, 'find_this');
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[frizzle]

Great!
As you've probably read, i didn't put the query in an array first.
Now everything works fine!
Thanks a lot!

Frizzle.