id like to save users emails to a text file.... is their an easy way to do this? thanks. :)
Easyiest way would be to grab them from the database
select email_address from smf_members
You can run that query via phpmyadmin
If it's to send everyone a newsletter, that's built in...
Quote from: vbgamer45 on August 30, 2020, 11:35:20 AM
Easyiest way would be to grab them from the database
select email_address from smf_members
You can run that query via phpmyadmin
can you give me more info? how would I do this? never have done it before. query the db.
If you have cpanel you might have a phpmyadmin section
From there you would select the database. Then run the query or use the export option
Here is a video i found on phpmyadmin https://www.youtube.com/watch?v=JgAyGjcNrIQ
how would I do a query on how to save all emails to a txt file? I know how to open the db in phpmyadmin and that is all I know how to do.
select email_address from smf_members
Works I think they have an option to exprot to csv file.
Don't think you can export a column, but just export the table as csv and load it into spreadsheet, then you can do whatever with the data.
Sir Osis of Liver -- vbgamer just indicated how to do it for just a single column
csv worked. thanks.
Quote from: Kindred on August 31, 2020, 09:09:08 AM
Sir Osis of Liver -- vbgamer just indicated how to do it for just a single column
Yes, I know, but that's using a query, not pma export. Some folks are not up to running queries. Couple ways of doing same thing.