How to delete rows only from yesterday

monkeyface

I have this field in the table called date it is YYYY-MM-DD.

now i want to delete all the records that are insterted yesterday. How can I do this?

thanks!

LordShryku

1) Calculate the date.
2) Execute the Delete SQL

monkeyface

i will try, if i dont succeed I LL BE BACK

monkeyface

but what about if it is 1 oktober. will i get 30 september or not when substracting?

LordShryku

$dt = date("Y-m-d", mktime(0,0,0,date(m),date(d)-1,date(Y)));
// or 
$dt = date("Y-m-d", strtotime("-1 day"));

monkeyface

yeah i figured the first part, however the second part i cant figure out. this sql query doesnt deletes all the records from yesterday:
the db connection and everything is ok!

// define the day of yesterday
$yesterday = date('Y-m-d', mktime (0,0,0,date("m")  ,date("d")-1,date("Y")));  


mysql_query("DELETE * FROM ref_count WHERE date = '$yesterday'") or die(mysql_error());

please help me!

LordShryku

No need for the *.
Just use "DELETE FROM ref_count..."