database corrupt

[Anon]

After about a day or two of my site running, i seem to get corrupt databases.......i can't enter or even view them. The only way to look at them is to delete all the entries, then everything is fine (except that i loose all my data). I was wondering if there is something I may be overlooking in my php code that is causing this?

PJB

[Anon]

When I try to download a screen show(file handle is invalid). Can you please help me fix my problem as soon as possible.

                                               THANK YOU
                                            FRANK JOHNSON

[[deleted]]

Uhm.. don't you think it might help if you at least told us
which type of database and OS you are using?

[Anon]

I'm using mysql on win98. When i ran myisamchk it seems that some of the tables didn't get closed. Then about an hour later it was corrupt.

I ran myisamchk just now, and everything seems ok. But is this happening because of user input or because of bad sql syntax?

in my header i open a connection, and in my footer i close the connection on every page. Is this the proper way to do it?