Changeset 334

Timestamp:

Jan 30, 2004, 11:49:24 PM (20 years ago)

Author:

z0rglub

Message:

if a category has no last_date, the corresponding date_last in user_category
table is also NULL

File:

• branches/release-1_3/admin/include/functions.php (modified) (1 diff)

branches/release-1_3/admin/include/functions.php

@@ -667 +667 @@
       $query.= ';';
       $row = mysql_fetch_array( mysql_query( $query ) );
-      $last_date = $row['last_date'];
 
       // insert a new line in database
       if ( $value_num++ > 0 ) $values.= ', ';
       else                    $values.= ' ';
-      $values.= '('.$user_id.",".$category['id'].",'".$last_date."'";
+      $values.= '('.$user_id.",".$category['id'];
+      if ( isset( $row['last_date'] ) ) $values.= ",'".$row['last_date']."'";
+      else                              $values.= ',NULL';
       $values.= ','.$user_nb_subcats.')';
     }