This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Mysql Select??

Old posts that have not been replied to for several years.
Locked
N
Neomaster
Voice
Posts: 25
Joined: Mon Feb 23, 2004 5:24 pm

Mysql Select??

Post by Neomaster »

I know that you can insert/update data in a mysql database.

How do you select data from a mysql database to show it in the channel from a command?? (command like !command)
User avatar
stdragon
Owner
Posts: 959
Joined: Sun Sep 23, 2001 8:00 pm
Contact:

Post by stdragon »

Make a bind for !command, in the proc for the bind you connect to the db, issue an sql select command, have a loop to read the results, use putserv to send them to the channel.

More detail really depends what mysql tcl package you're using. I suggest reading the docs.
N
Neomaster
Voice
Posts: 25
Joined: Mon Feb 23, 2004 5:24 pm

Post by Neomaster »

Thanks.
Locked