Re: Exceptions in PHP

do you know what a php exception is and when/where/what generates them? (if your coming from another language that supports exceptions you may need to adjust your knowledge - php's exceptions are a little different - for instance they are not ever generated by the engine itself) does mysql_query() generate exceptions? does mysql offer transactions in it's default storage type? are tansactions on by default in storages types that support transactions? answering these questions will probably shed some light on why your script doesn't do what you think it should. John Meyer wrote:

I have the following script:

...

I'm trying to get to the point where if the query doesn't execute, it pops out a message and rollsback any possible results. It doesn't. What's wrong on this script?

well it has a big security hole going by the name of 'sql injection'. if you google 'sql injection php' you should get lots of info on what it is and how to fix the problem.