Re: Code Check

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



janbro wrote:

Hi List, I don't know where else to look. I've got PHP 5.0.0 and MySQL
4.1.3. (on Windwows XP with Apache 2.0.50)

Here is my Code: the Query with the delete is not executed and I don't
know why. If I copy it into the MySQL Command line like it is here,
everything works fine. I have another example with a more simple delete
which works (same syntax)

If I replace the delete with the insert statement it works.

What 'am I doing wrong here?



public function DeleteOldFails (){
		$conClas=$this->con();
		$con=$conClas->mysqlConnect ();
		
		$query = "DELETE FROM LoginTracker WHERE (UNIX_TIMESTAMP(CURRENT_TIMESTAMP) - UNIX_TIMESTAMP(DateAttack)) > 3600;";
//		$query ="INSERT INTO LoginTracker (IPAttack, User) VALUES ('127.0.0.1','user')";
		echo "$con<br>Diesen Auf ERFOLG TESTEN! LÖSCHT ER WAS ER SOLL? <br>$query<br>";
		print $con->query($query);
			  $con->query("OPTIMIZE TABLE LoginTracker ");
$this->discon ($conClas, $con);
	}

thx
janbro

Have you checked that the two previous function calls are returning as expected?

HTH,

Mikey

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux