> > Is there a different syntax to the mysql delete statement when the "WHERE" > > clause points only to half of the primary key? > > > > The structure is as follows: > > CREATE TABLE IF NOT EXISTS ` table1` ( > > `id1` int(10) unsigned NOT NULL, > > `id2` int(10) unsigned NOT NULL, > > PRIMARY KEY (`id1`,`id2`), > > KEY `id2` (`id2`) > > ) ENGINE=MyISAM DEFAULT CHARSET=utf8; > > > > Query is > > $query = "DELETE * FROM table1 WHERE id1 = '$recID';"; > > Integer values do not need to be quoted. You should be able to drop the > semi-colon from the query too. See if that helps > > > Error is a 1064 syntax error. And try var_dump()ing the complete query to make sure it looks as you would expect. > > Any help is appreciated. > > > > Eli > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > Niel Archer > niel.archer (at) blueyonder.co.uk > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
