Deleting Old Data From Database

PHP
1

I need to removed old data from a database. It does not have a date field but the date is in the title field like:
10/14/2010

Is there anyway possible to use the date in the title field to remove any data before today’s date?

2

if this is always in the same position in the title, you can use the mysql STR_TO_DATE function for the compariso

yes … if the date is same place in the title, you can have it done with some php code and 1 db query …

the field " title " contains more than the date ? << the title i guess ?

3

YOu must add a date column using the existing info.

4

if this is always in the same position in the title, you can use the mysql STR_TO_DATE function for the comparison

5

yeah, create a date field. Use PHP’s [fphp]strtotime[/fphp] function to convert your current string into a Y-m-d format and save back into MySQL.

You can then easily select rows by date in your SQL query.