Code Check

From: Date: Mon, 30 May 2005 19:37:41 +0000
Subject: Code Check
Groups: php.general 
Request: Send a blank email to php-general+get-216005@lists.php.net to get a copy of this message
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

« previous php.general (#216005) next »