Re: Code Check

On 5/30/05, janbro <janbro@web.de> 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 > -snip- $query = "DELETE FROM LoginTracker WHERE (UNIX_TIMESTAMP(CURRENT_TIMESTAMP) - UNIX_TIMESTAMP(DateAttack)) > 3600;"; -snip- Take out that ; after the 3600! Dotan Cohen http://lyricslist.com/lyrics/pages/artist_albums.php/345/Metallica