[RESOLVED] Problem with DELETE FROM

interface

Here's the problem:

I'm working with Microsoft Access (Yeah, I know, don't bug me about it 😉
It may sound kinda stupid, but I seriously have a problem deleting records by ID.

$rs = $db->execute("DELETE FROM some_table WHERE ID='theID'");

This doesn't work though ..
I've tried several different queries but it still doesn't work.
If anybody has an idea (and I'm sure someone has) don't hessitate
to post an answer or just to point me in the right direction.

Sincerly,

interface

TobyRT

The query looks sound (although I confess, I'm not familiar with Access)

My inclination would be to double check your $db variable.

Do you get any error messages?

Are you successfully connecting to the database?

interface

The error message I get is that I have a 'mismatched criteria'.
If I take the same querie, but then a SELECT:

SELECT * FROM some_table WHERE title='some title'

The above works.

SELECT * FROM some_table WHERE id='some id'

The above doesn't work ...

Form some reason I CAN use 'delete' and 'update' and 'select' queries without problems, UNLESS I try to address an ID. These ID's are automaticly inserted in the ACCESS table. (Autonumber).

The $db variable is OK, the rest of my 'website' works fine with it. It states the connection parameter for an microsoft jet engine database.

Sincerly,

interface

Strange no? 😉

wreed

take the ticks out of around id...if its an int field you don't need them.

SELECT * FROM some_table WHERE id=5;

interface

If your solution works then you just made me feel like an idiot 😉
So instead of id='117' use id=117?

I'm gonna try it in a few hours (WHERE hours='3') when I'm at
home. And when this works I'm gonna smack /me with a trout ...

But then again, I just started with PHP like 2 weeks ago, so
I hope the trout goes easy on me ...

Thanks in advance, if it works, you'll be the first to know.
BTW, wreed, as in 'dat is wreed man ... !' ?

Sincerly,

interface

That trout still hurts wreed ...