Query Err

Hello,

I have a problem with sql query this query is working fine in Phpmyadmin but didnt work when i use it in my Php page what might be the problem.

$query= "
DELETE From 'emails'
Where
'id' = '1'

mysql_db_query ($db_name, $query, $connection)
or die ("Could not execute Query delete Email");

'id' = '1'
incorrect

id = '1' - correct (I think :-)

hi thanx any way i got the solution myself.

The query is behaving abnormal dont khow why.

$query= "
DELETE FROM emails
Where
id = '1'
";

mysql_db_query ($db_name, $query, $connection)
or die ("Could not execute Query delete Email");

Just remove the ' ' from id

Any one have its suggestion why it is behaving like that.

Regards.

Any one have its suggestion why it is behaving like that.
:-)) It's MySQL syntax only.
Name fields in ticks (`) or without it. No apostrophes (').

Thanx but i was worried buz when we used to insert of fetch data from mysql it wount give err and the query is executed correctly with ' ' .

Thanks any way.

But my point isnt clear.