Gossamer Forum
Home : Products : Others : MySQLMan :

command to list all data on one page

Quote Reply
command to list all data on one page
I had to change the software for one of the sites i own on my server so i need to retrieve all e-mails from the old database to send an e-mail to old members to join the site again.
using mysqlman i clicked on sql monitor and entered
SELECT * FROM email ORDER BY id LIMIT 0, 20
but it only list 20 e-mails per page even if i change 20 to 100
what command do i need to use to list them all on one page?
Quote Reply
Re: [theguy] command to list all data on one page In reply to
2 weeks and nobody answered me. please someone help me
Quote Reply
Re: [theguy] command to list all data on one page In reply to
Unfortunatly mySQLMan is pretty out of date ... you would probably be best to use phpMyAdmin to do the task you need (much newer, and constantly updated)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates