[SOLVED] MySQL Delete Row Suggestions

[stormx]

I have no clue where to start but would anyone have any suggestions on a PHP script that gets a specific date from a MySQL database table, and when the date comes the cron will delete the nominated MySQL row.

 

If you didn't quite understand what I mean, here is another example:

 

Cron >> Gets specific date from MySQL row >> If that date is the same as today’s date it will delete the row.

 

I have no clue where to start and I am very new to PHP, could anyone give an example PHP script or a recommendation.

 

Thanks 

[Adam]

$query = mysql_query("DELETE FROM yourTable WHERE dateField = '" .date("dmy"). "'");

 

Look into PHP's date() function so you can format the date to how you have it in your database..

 

Adam

[stormx]

Is it possible to do an INSERT function with the same date scheme?

[premiso]

Is it possible to do an INSERT function with the same date scheme?

 

Entirely. Best way to find out, however, is try it yourself and see =)

[stormx]

Thanks guys, this was my final code:

 

<?php

error_reporting(0);


session_start();

include 'my_sql.php';


$sql_users = mysql_query("SELECT `username` FROM `users`") or die("Error Selecting ID from users.</strong>");


while($id = mysql_fetch_array($sql_users)) {

mysql_query("UPDATE users SET suspended = '1' WHERE username = '$id[username]' AND end_date = '" .date("n/j/Y"). "'");

}

?>

 

Works like a buzz