Need a little MySQL help?
Here's my problem. I have a site where users can delete titles. The problem is that when a title is deleted it screws up the database.
How can I fix this?
I'm using an auto_increment field and using that field to link to certain titles.
Thanks.
Stace
Abhishek Reddy posted this at 04:21 — 30th December 2004.
He has: 3,348 posts
Joined: Jul 2001
I think a clearer description of the problem might help. What is a title? What do you mean by "screws up the database" -- what actually happens? Do you get error messages? What are they? What software and language are you using?
Welcome to TWF.
Busy posted this at 11:03 — 30th December 2004.
He has: 6,151 posts
Joined: May 2001
I'm guessing you're getting overhead values in myphpadmin ?
to clear these just select row and choose optimize
more details would help
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.