Nonexistent fields showing up

[jake4974]

It is strange, I have this field in a table thats not cooperating.
I deleted it using the phpmyadmin interface, but it still showed up.
So I tried deleting it with straight sql, and got a nonexistent field error, but it still returns in select results.
I'm stumped, any ideas?
Sorry, row that is not cooperating.

[longneck]

try running a repair on your table.

[jake4974]

Weirdness, still showing up. Oh well, fortunately I can just ignore it. Pretty weird though.

Btw, thanks longneck

[longneck]

can you post the create table for the table in question, along with the SQL command you used to delete the column?

[jake4974]

Sorry, that original post and it's title are actually pretty misleading.
It is a row of data I cannot delete for some reason, seems to drop/add columns with no problem.
Originally I had 7 certain rows in one table, I can't remember why, but I needed to actually split these 7 into separate tables, so I just copied the table and deleted unnecessary rows. This one row would not delete "correctly" in many of the tables. If I just recreate the structure an insert only the necessary data, it's all good.