The following table is refreshed once a night as a report from the last day: +---------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+-------+ | item_type | tinyint(3) unsigned | | PRI | 0 | | | item_id | char(4) | | PRI | | | | peak_date | date | YES | | NULL | | | peak_hits | int(10) unsigned | YES | | 0 | | | peak_users | int(10) unsigned | YES | | 0 | | | date_start | date | YES | | NULL | | | date_update | date | YES | | NULL | | | total_hits | int(10) unsigned | YES | | 0 | | | total_users | int(10) unsigned | YES | | 0 | | | total_nedstat | int(10) unsigned | YES | | 0 | | +---------------+---------------------+------+-----+---------+-------+
Now i have this really weird thing that i can't figure out... i insert or update the data from this table and it seems correct, after all operations have been done i do an OPTIMIZE to all tables. So this data ONLY get changed ONCE a night but a few hours after the operations are finished the total_hits column gets reset to NULL for ALL rows ! First this column was a BIGINT, so i thought that that might be the problem but it still does it with INT. I really don't know how why or when exactly it's doing this :o( Groetjes, Tiele Declercq [ [EMAIL PROTECTED] ] --- Projectleider Start.be http://start.be
