Form Lists and PHP

[golfinggod]

Hi quick question

I have a field in mysql called websites that holds a list of urls.

Is there any way to fetch this list and then display the results in a form list menu. I have the select query below, but i am not sure how to write the rest of the code. Would i echo the main part of the list above the while statment and then echo the <option> tag within the "While" any ideas ?

$Selectid = "SELECT website FROM banners WHERE Username = '$Username'  "; 

      $Result = mysql_query($Selectid); 

	  if (mysql_num_rows($Result) >0) 

	  {

	  while ($users_row = mysql_fetch_array($Result)) { 

////////////// need help create the form list


}

[kerodeon]

Simplest way i can think of:

$Selectid = "SELECT website FROM banners WHERE Username = '$Username'  ";  

      $Result = mysql_query($Selectid);  

      if (mysql_num_rows($Result) >0)  

      { 


      // creates array for each site url
      $users_row = mysql_fetch_array($Result))   

then put <?php print "$users_row["sitefieldname"];" ?> wherever you need the site url put, just create the list menu in normal html.

I hope i understood what u wanted, if not just post and clarify what you need.

[golfinggod]

Thanks for the help. Yep It did work 😃