Resolved delete entry, but with exception php mysql

[sonny]

Hi

I am trying to delete all entry's before a certain date, "except those matching testfolder"
this should work I think, anyone see why it doesn't? it deletes everything.

My php form's query

PHP Code:

$sql = "DELETE FROM `$tbl` WHERE `$field` < '$before' NOT LIKE url='%/testfolder/%"; 


Thanks
Sonny

[Fou-Lu]

There's no AND condition in there.

[sonny]

Originally Posted by Fou-Lu

There's no AND condition in there.

PHP Code:

$sql = "DELETE FROM `$tbl` WHERE `$field` < '$before' AND url NOT LIKE '%/testfolder/%"; 


works now

Thanks
Sonny

[guelphdad]

well yes you would.

You are basically saying:

select * from cars where color='black' and 'four'

you want

select * from cars where color='black' and wheels='four'

you have to specify which field you are checking after the AND, which you have not done above.