[Moderator]

I'm working on a site that has about 100 member listings and will grow to about 1000. I want to just keep adding the names to the database as I get them and have them update in the HTML page...without having to add them manually to the HTML page each time I add a few names.

I can't use the Library feature of Dreamweaver because the listings include email addresses and URL's, or can I?

I don't know much about database driven sites so I'm wondering if there is a simple way to do this with Dreamweaver..or do I need UltraDev?

Also, I'm on a Mac.

Thanks for the advice

[torifile]

Use PHP to query the database and echo out the results in while loop with formatting tags within the while loop. Example:

<BLOCKQUOTE><font size="1"face="Geneva, Verdana, Arial">code:</font><HR><pre><font size=1 face=courier>
$query = <font color = red>"SELECT username FROM users"</font>;
$result = mysql_query($query);
while($query_data = mysql_fetch_row($result)) {
$regusers = mysql_result($result,$i,<font color = red>"username"</font>);
echo <font color = red>"$regusers"</font>;
}
</font>[/code]

This will query a table named users and get all the usernames. It will then go through the results and print each username. I know that there's a more efficient way to do it, but that's how I do it. As for doing this in DW, I have no idea.