Re: deleting rows with composite primary key

> 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. > > 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