Stephen Pearce wrote:
Hi Is there anyone who could guide me thru the installation and setting up of a MySQL database using pHp and apache.
This is for an ICU database in a hospital .. so not a strictly commercial objective
Installation of the software (mysql, php, apache) can be done easily using your distros installation tool, and there is plenty of info about that around in HOWTO docs and the likes. Try Google for that stuff. You probably will also want phpmyadmin. Designing an appropriate database structure and writing a web application to run it is a different task altogether. Last time I looked (a couple of years ago, so maybe someone has some more current info) there didn't seem to be any easy db design tools available. At the time I used MS Access to prototype the db I wanted, and I think I remember that you can export SQL from access, so you can use that to get your db into mysql. Now if I had to do that task I'd probably use MS Visual Studio to do it, but I guess that's not the answer you need. If anyone has any suggestions for open source tools that can do this I'd be interested in some pointers too. I don't know what ICU is, but have you tried looking for existing open source apps that already provide the functionality or that provide most of it so that you only have to add the bits you want? g -- Glenn Ramsey <glenn(a)componic.co.nz> 07 8627077 http://www.componic.co.nz