Thank you man :)
-----Original Message-----
From: Robo Kupka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 27, 2005 4:55 PM
To: [email protected]
Cc: לאון קולצ'ינסקי
Subject: RE: delete the log at database
Hello Leon, Christian,
I'm glad my script helped you both. Here is modified version (just one variable
moved out from cycle), works a bit faster....
<?php
$connection = mysql_connect("localhost","mail","yourpassword");
mysql_select_db("mail" , $connection);
$users = mysql_query("SELECT user FROM log GROUP BY user",$connection);
while ($user = mysql_fetch_row($users))
{
echo "Spracovavam log usera ". $user[0]."\n";
$result = mysql_query("SELECT * FROM log WHERE user =
'$user[0]' ORDER BY id",$connection);
while ($row = mysql_fetch_row($result))
{
$numfields = mysql_num_fields($result);
for ($i=0; $i<$numfields; $i++)
$index = $row[0];
}
$result = mysql_query("DELETE FROM log WHERE user='$user[0]'
and id != $index",$connection);
}
echo "Cistenie logu prebehlo" . date (" - d.m.Y., H:i:s") . "\n";
$result = mysql_query("OPTIMIZE TABLE log",$connection);
echo "Tabulka log je zoptiomalizovana \n";
mysql_close ($connection);
?>
Best regard
Robert Kupka
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
