---------- Forwarded message ---------- From: Piyush Kumar <piykumar@xxxxxxxxx> Date: Thu, Oct 16, 2008 at 9:09 AM Subject: Re: MySQL Query Timeout program in PHP To: Chris <dmagick@xxxxxxxxx> Hi Chris, As I mentioned in my query I want to Kill only the query ran by web client not all queries running on the server. The perl script kill all queries - which are been running from for last 120(or any threshold set) Issues: How do I get the PID of my last select query ran from the web query interface..?? Any php function..? Thanks Piyush On Thu, Oct 16, 2008 at 7:35 AM, Chris <dmagick@xxxxxxxxx> wrote: > Piyush Kumar wrote: >> >> I'm using http://myclient.polarlava.com/ as web query interface for mysql >> server >> >> Now I want to add "Query Timeout" functionality to it >> >> For that I need to get the PID for last ran mysql query and then using >> kill >> PID - I can kill the process on MySQL server >> >> Please explain how to do that in PHP Thanks! >> >> Similar to what described @ http://bytes.com/forum/thread156058.html > > Learn some php and convert the perl script? > > What area are you having issues with exactly? > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > -- Thanks & Regards, -Piyush Mo.: 091-9910904233 Mail: piykumar@xxxxxxxxx Web: http://piyush.me/ -In a world without fences, limits, boundaries and walls, Who needs Windows and Gates? -- Thanks & Regards, -Piyush Mo.: 091-9910904233 Mail: piykumar@xxxxxxxxx Web: http://piyush.me/ -In a world without fences, limits, boundaries and walls, Who needs Windows and Gates? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php