I am developing on a LAMP web server. The server, however is remote from me and I am not able to connect to it through a BASH shell. At this current time, my only means of accessing and manipulating the database is through PHPMyAdmin. After a lot of research, I believe that having several sproc's would dramatically enhance the speed of the pages loading. However, I have searched through PHPMyAdmin and have not been able to find a way to create and store sproc's through it. If anyone can help me out at all it would be greatly appreciated.
Welcome to WebmasterWorld, hsteckylf! And you too, listerine!
MySQL 5.0 [dev.mysql.com] is the current alpha release of the MySQL database server. Since it is still in alpha release, you are using it unsupported and may yet uncover issues. I've been down this road before and if you aren't pushing the bar too far it may be worth the risk if you truly want to start using stored procedures in a LIVE installation. However, as with anything, individual assessment is necessary. Best wishes with the endeavor -- coopster