Please help, want to delete a charachter from the comicsite database but get an error message , unknown table 'char_main' in MULTI DELETE. I have used my own type code , then tried the downloaded coded p298 case "Delete Character" both give me the same error.

I then changed the code to the long names eg char_main.lair_id instead of m.lair_id. This take me to a different error message:

You have an error in your SQL syntax, check the manual ..... to use near 'WHERE char_main.lair_id=char_lair.id AND char_main.id=19' at line 1.

Please , please help. I am using php Version 5.0.4 with apache 2.0 on a windows XP machine