My site allows people to register their site without the need of pre-registration. When someone adds a site i ask for various details inclusing contact e-mail address. Now i have many e-mail addresses entered, is there a quick and easy way to just extract those e-mail addresses?

Initially I used Open directory which of course doesn't have any contact e-mail addresses, so all i want is the new ones that people are now entering.

thanks

Leslie

In the SQL monitor:

select field_name from prefix_Links

set field_name to the field -- ie: Email (?)

and prefix to what you set your prifix up as (lsql)


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

If you want to extract to a file you can use MySQLMan's export feature. Just select the email field and export - its very easy to do.