[doublee313]

I have a database called "survey" in there I have a table called "surveylist" with the following entrys:

survey1
survey2
survey3

I want to grab those entry from surveylist and list them in a dropdown box in my code. I have the following code sofar, but am kind of lost. Can someone please help me fill in the blank? I'm a newbie, so please understand.

PHP Code:

// Connect to your MySQl server

        $server = "localhost";

        $user = "xxx";

        $pass = "aaa";



    $conn = mysql_connect ($server,$user,$pass) or die(mysql_error());



    mysql_select_db ("surveys") or die(mysql_error());

    $get = mysql_query("SELECT * FROM surveylist"); 

    $get = mysql_num_rows($get); 

        echo "<option value=\"$row[0]\">$row[0]";

echo "<select name=survey>"; 

[snaip]

Have a look at the following threads:

http://www.programmingtalk.com/showt...light=dropdown
http://www.programmingtalk.com/showt...light=dropdown