|
|
Posted by janbro on 10/21/61 11:17
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
Navigation:
[Reply to this message]
|