Re: [PHP-DB] 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.

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