mysql php drop down menu array

[rulian]

PHP Beginner.
Situation:
I have a table called files with coloum 'filename'. What I want to do is do a mysql query to get all the different types of filenames. lets say it returns 10 of them. Then, every filename has an assosicated search string in the 'search' coloum which I want to as a second variable. Now i want to list these tens in a drop down menu using the filename as the option and search name as the value.
How would I go about this, my code doesnt seem to want to work.
code:
$getfiles=mysql_query("select filename, search from files");
$amount=mysql_num_rows($getfiles);
echo "<select name=search>";
for ($i=0, $i<$amount, $i++){
$name=mysql_result($getfiles,$i,'filename');
$value=mysql result($getfiles,$i,'search');
echo "<option value='$value'>$name</option);
}
echo "</select>";

[bouche]

This should do the trick.....

<select name="search">
<?php
$query = mysql_query("select filename, search from files");

while ($row = mysql_fetch_array($query))
{ print "<option value=\"$row[search]\">$row[filename]</option>"; }

?>

</select>

[ricky_000]

Hi Rulian,

I got an similar project that you are doing. I am having a lots of problems. Could you share your code so it could guide me to create my script. Please i need help. Could you be so kind to help me. Thanks a lot.

[Anon]

What code to you need? to turn an mysql array into a drop down menu, that's very simple, call you need to do is assign the two variables involved in the drop down menu, -> value and text: take this code for example

function options(){
$query=mysql_query("SELECT option, value from wherever");
if (!$query)echo "Error in query";
else {
$count=mysql_num_rows($query);
if ($count==0) echo "Nothing found";
else {
for ($i=0; $i<$count; $i++){
$OPTION=mysql_result($query, $i, 'option');
$VALUE=mysql_result)$query, $i, 'option');
echo "<OPTION VALUE=$value>$OPTION</option>";
}
}

echo "
<select name='select'>
";
options();
echo "</select>";

hope this helps

[ricky_000]

Thanks Rulian. I appreciate your answer.

Let me tell you what i am doing.

I need to create a drop down menu that will allow the user to select different product categories such as blenders, can openers, etc. Then after selected will return lets say 10 model numbers (keeping same background),so the user can select the model number and then a file will open up in a new window like pdf with instructions. I have been looking everywhere. I need some real help, so i thought your script was very similar to what i need to do. If you dont mind sharing or helping. I would really appreciate it. This is without any profitable purpose.
I am learning, however, i need some help. Could you please help me. Thanks a lot.

[Anon]

Well, I'm sorry, but my script doesnt do that, but what you discribed doesnt seem to different of difficult, the only thing is that the user is going to have to refresh the page every time he makes a selection unless you use java scripts of some sort. But here is how you can do it:

use the previous script to make your pull down menu, set the value of the options to the catagory identification number/marker, when the page reloads, you can then use that catagory ID to select the options for that catagory, you can do that in your query:
mysql_query("select * from catagory_options where cat_id = $catagory");

and then run the previous script again, substituting that first query for this one, except that return value will be a diffent thing, like a page number, or catagory number, at which point when the page reloads again, you can display the appropriate page.

hope it helps, let me know if I can help any more