Dynamic select field php

programming
1

Hi there

I’m putting a form in a database driven website. At the select field, I would like to retrieve the information from the database as a drop down menu.

Here’s my code : - which I put inside the form :

   
              $query = 'SELECT `Name` FROM desta_services';
                        $result = mysql_query ($query)
                        or die ('Query failed');
                        echo '<select name="category">';
                        while ($row = mysql_fetch_array ($result)) {
                        echo '<option>'$row['Name']'</option>';
                        }
                        echo '</select>';

It doesn’t work??? Can anyone tell me what the prob is?

Thanks!