Trophimus
05-06-2006, 10:08 PM
Hello there,
I am looking to create some sort of database where my staff can log information about a caller, and then view the information my staff submit in an open directory. Does anyone know of some sort of script that I can use to-do this?
Thanks,
Tim
iyeru42
05-16-2006, 07:17 PM
Yeah, install MySQL on your server, then use phpMyAdmin to insert a bunch of stuff, and use PHP to:
mysql_query('SELECT * FROM this_damn_table');
Googled
05-17-2006, 01:49 AM
I also recommend MySQL, free, fast, stable, proven product.
FlightLizard
05-17-2006, 01:55 AM
This type of system is usually referred to as a Customer Relational Management System. Used often in call centers.
If you will be getting alot of calls then yes create a db with MySql and use php to set up the coding and a web based interface. . If you think its going to be small - like <10 calls a day you probably could whip something up with MS Access.
Just thought if on a windows server the MS SQL express edition is also available - do not know though how many simultaneous connections it will allow. You could connect to it useing php or ASP scripting (if on Windows)