Ok, I added a primary key. I figured it out and I have it working... Thanks!
"Chris Shiflett" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > --- zavaboy <[EMAIL PROTECTED]> wrote: > > Lets say the table contains the following rows (user | item): > > 582-668243 | Toothbrush > > 582-668243 | Toothbrush > > 582-668243 | Toothbrush > ... > > Anyway, how can I remove only 1 Toothbrush from user 582-668243? > > With the information you provided, you can't. You should never have multiple > rows in the database that are non-unique, and this is one reason why. You need > a primary key. > > > I just want the query > > You should rather spend your time learning some database fundamentals rather > than asking this list (not a database list, in fact) for spoon-fed answers. You > will appreciate the knowledge more than the answer. > > Chris > > ===== > Become a better Web developer with the HTTP Developer's Handbook > http://httphandbook.org/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
