Sandbox

Not being a programmer, need a little help on this one .

Need to read users from jos_users (or when using community builder, perhaps another table?) from a script and output to a text file with one user on each line.

Can someone give me a mysql command which will allow me to do this from a script.

Thanks very much.

Mike

If you have phpMyAdmin on the server, it allows you to export tables to a heap of different formats like CSV, Excel etc...

If you do have it, you will be able to find guides on how to export data

I do have it but I need this to be a command line script so that I can automate it.
Unless you're saying I can use it from the command line to achieve what I'm after?

What I need is output which can be read by another program later. That the output show only new accounts created and accounts removed. Not sure how it would show removed since they would be gone.

Mike