deleting rows with composite primary key

[email protected] ("Systems")
Newsgroups php.db
Message-ID <[email protected]>
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';";

Error is a 1064 syntax error.

Any help is appreciated.

Eli
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.