View Single Post
Old 02-25-2004, 05:18 AM   #2
alivin70
Orange Mole
 
alivin70's Avatar
 
Join Date: Sep 2003
Posts: 40
Hi,
thank you for your code.

Why you do this:
PHP Code:
$query "SELECT l_id FROM ".PHPDIG_DB_PREFIX."logs";
$id mysql_query($query,$id_connect);
while (list(
$key_id) = mysql_fetch_row($id))
       {
           
$query_delete "DELETE FROM ".PHPDIG_DB_PREFIX."logs WHERE l_id=$key_id";
           
$id_del mysql_query($query_delete,$id_connect);
           
$del++;
       } 
why not a simpler:
PHP Code:
$query_delete "DELETE FROM ".PHPDIG_DB_PREFIX."logs";
           
$id_del mysql_query($query_delete,$id_connect);
$del mysql_affected_rows($id_connect); 
thanks
Alivin70
alivin70 is offline   Reply With Quote