cancelling http requests / queries

[marckula]

I have a php web app that interacts with a mysql database. If I click a link that starts a long sql query then, while waiting for the result, immediately click another link on the page to begin another (shorter) query, is there a way to cancel the initial query? Basically, I would need to cancel the prior http request right??

not sure this applies to PHP or Apache.

[drew010]

in php by default, when the client disconnects the connection either by pressing stop, closing the browser, or getting another link, the php script terminates itself. sounds like this is the behaviour you want, if youd like to change it, see [man]ignore_user_abort[/man].

[marckula]

ok, good. is there any way to cancle any mysql queries that would be running?

[drew010]

as the php script itself terminates, so does the connection to whatever databases its connected to.