Displaying MySQL table data in a textarea

programming
1

Hello all:

I’m trying to display all of the email addresses I have in one mysql database table in a textarea. I’ve been using the following code:

 $result = mysql_query('SELECT * FROM `email` WHERE 1 LIMIT 0, 30 ');
<?php while($row = mysql_fetch_array($result)){ ?>
<textarea name="textarea" cols="" rows="" wrap="virtual"><?php echo $row['email']; ?></textarea>

When I view it, I want all of the email addresses to show in one textarea, but it is presently duplicating the textarea based off of how many addresses there are in the table. I know it has to do with improper use of mysql_fetch_array, but I’m not sure where or how.

Any help would be appreciated. Thanks.

JPearson311