php - Populate dropdown menu from MySQL database? -

i have read few threads can not figure out solution problem. want display names of different events in table 'events' in dropdown menu.

the code have is:

<?php mysql_connect('localhost', 'root', ''); mysql_select_db('test');  $sql = "select 'event name' events"; $result = mysql_query($sql);  echo "<select name='event name'>"; while ($row = mysql_fetch_array($result)) { echo "<option value='" . $row['event name'] ."'>" . $row['event name'] ."</option>"; } echo "</select>";  ?> 

i getting drop down menu displays 'event name' 3 times. have 3 entries in event name table not displaying names?

now after nathan's change, error should seen space between field name , apostrophe on around field. need remove apostrophe , space between fieldname.