Is it possible to dynamically populate a textarea with data from a database?

[Ariel]

Hello,

I'm trying to re-create a listbox with the textarea element. Is it possible to dynamically populate the textarea with data from a database?. I want the data to list vertically like a listbox.

If this possible, can you please provide an example of how I can go about doing this?.

Thanks,
Ariel

[QuietDean]

Sure. Heres an example -

$result = mysql_query("SELECT * FROM league_news ORDER BY ident DESC",$db);
    
    
    printf("<form method=\"post\" action=\"news_handler.php\">\n");
    printf("<select name=\"todelete\">\n");
    
    
    
    
    while ($myrow = mysql_fetch_row($result)) {
    
    
    
        
    
    
    
    printf("<option value=\"%s\"> \n", $myrow[5]);
    printf("%s\n", $myrow[0]);
    printf("</option>\n");
    
    
    
    
    
    }
    
    print("<input type=\"submit\" value=\"delete\" style=\"padding: 0px; font: 9pt verdana, sans-serif;\">");
    printf("</form>");
    
    ?> 

Edit: Oops. That how to fill a select, not a textarea, sorry.

But the principal is the same. Write the textarea, then a loop from the database echo'ing or printing out what you need. Make sure you put a \n or \r\n character at the end of each to keep them separate.