feyd,
Thanks for the quick response. The table is being created using this statement (through PHP):
Code: Select all
$tmpsql3 = "CREATE TABLE `tmptable` (
`julian` int(11) NOT NULL default '0',
`title1` varchar(50) character set ascii collate ascii_bin default NULL,
`event1` int(11) default NULL,
`recval1` varchar(50) character set ascii collate ascii_bin default NULL,
PRIMARY KEY (`julian`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
In PHP Admin, when I browse the file, all the rows (I'm trying to delete) are
NULL all the way across, aside from the first column (Julian). Unfortunately, I can't do a data export (sensitive data). Here is the error I'm getting when I try to run the process from PHP:
Error! Could not delete data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; DELETE FROM tmptable WHERE ((tmptable.title1 is NULL
Thanks again,
Anthony