delete the table row automatically

[phpmady]

Hi,

 

I want to delete the row in the table, based on the expiration of the date.

 

for example ::now i have

 

id name    date

1  xxxx    30.05.10

2  yyyy    31.05.10

 

 

what i want is, today 30.05.10 so i want to have only 1 row i.e

 

id name    date

2  yyyy    31.05.10

 

 

 

Thanks

 

 

[ohdang888]

You'll need to set up a CronJob on your server to call a file on your server that will have a DELETE query

http://en.wikipedia.org/wiki/Cron

 

You can set the cronJob to go off at midnight every night to delete the days rows.... though i don't udnerstand why you would want to do this? unless the table is just getting huge, why not keep them and use WHERE clauses with your SELECT queries

[phpmady]

You'll need to set up a CronJob on your server to call a file on your server that will have a DELETE query

http://en.wikipedia.org/wiki/Cron

 

You can set the cronJob to go off at midnight every night to delete the days rows.... though i don't udnerstand why you would want to do this? unless the table is just getting huge, why not keep them and use WHERE clauses with your SELECT queries

 

 

 

thanks for your suggestion, that means how to write the select query for that

 

am having my date in unix timestamp

 

thanks

 

 

[ohdang888]

easiest way to do it is to make another column that has the date in the format you said u did (31.05.10)

 

$day = date('d.m.y');

$query = "SELECT * FROM table_name WHERE day='$day' ";