GOOOOOAL!

Finally, I have had some success with MySQL stored procedures in phpMyAdmin.

This controller software IDE called AspectFT Studio makes it very difficult to control triggers. Any value sent as a trigger input will trigger the code to execute, and there is no way you can set up logic to sometimes trigger, and other times not. Any logical sequence will result in at least a one or a zero, which will both activate a trigger.

Luckily they allow you to read and write to a database, so I can write my code in a stored procedure. They only have support for MySQL and and SQLite, and they suggest we use XAMPP for small projects (they will provide a server for mucho deniro, and they suggest we go that rout, and I can see why - there stuff hardly works without it).

So after much ado, I have finally harnessed the power of stored procedures in MySQL. I am posting this very much prematurely though, because I still have to test it. Just because I got it to compile doesn't mean my logic is perfect.

*think*

LOL. My logic, not perfect. I'm laughing so hard I'm almost crying.

No, seriously, I might still have some mistakes. Lets check . . . no mistakes, big surprise.

I'm not saying my code is perfect, but it works. Do I have a big head or what?

;p