[PHP-DB] perl module to filter data to prevent SQL injection

Hello, I'am searching for a perl module to prevent SQL injection. Target is a simple logfile I need to analyse. I read the manpage from DBI where the function quote has been discussed, but not sure if this is the correct way. -- Best Regards, Mark -- PHP Database Mailing List (http://www.ph

[PHP-DB] how to filter data to prevent SQL injection

Hi, I'am searching for a perl module to prevent SQL injection. Target is a simple logfile I need to analyse. I read the manpage from DBI where the function quote has been discussed, but not sure if this is the correct way. -- Best Regards, Mark -- PHP Database Mailing List (http://www.php.n

Re: [PHP-DB] delete time related data inside a table within 1 hour

Hi Martin, > http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html says > that's the right format. Are you sure you're storing the time and not > just the date? I'd wager that it will delete immediately if you are > only storing the date. I agree as it is the right format but when I us

[PHP-DB] delete time related data inside a table within 1 hour

Hello, to delete old entries within 1 one day I use this: $sql = ("DELETE FROM orders WHERE time_date < DATE_ADD(NOW(), INTERVAL -1 DAY)"); Now I would like to delete within a timeframe of 1 hour. But when I change the above statement to 1 hour or -1 hour it deletes immediately. Maybe someone