[SOLVED] Delete row by matching two fields

[sonny]

Hi folks

 

I would like to delete a row based on a keyword

But only if another field matches  vcode="0" as well

 

my delete from query is below, but does not work, I am very new to this

 

$dkey="%".$keyword."%";
mysql_query("DELETE FROM visits WHERE url LIKE '$dkey' && vcode='0'");

 

Thanks

[daneth1712]

just a thought... maybe try setting a variable for vcode and changing && to AND.

 

$dkey="%".$keyword."%";
$vcode="0";
mysql_query("DELETE * FROM visits WHERE url LIKE '$dkey' AND vcode='$vcode'");

[sonny]

just a thought... maybe try setting a variable for vcode and changing && to AND.

 

$dkey="%".$keyword."%";
$vcode="0";
mysql_query("DELETE * FROM visits WHERE url LIKE '$dkey' AND vcode='$vcode'");

 

Thank you, just the "AND" instead of "&&" did it

Sonny