calling all php gurus

[jonnyb]

Hello,

In my mySQL database I have a field 'dateadded' (timestamp)
//returns this sort of thing 20030324114222

I've used flash to call php every 5 minutes. Then delete any records that are older than 15 minutes
eg $query = "DELETE FROM $db_table WHERE $newdate >'dateAdded+20'";

but I need the present date...

$newdate = strtotime ("now");// returns this format 1048508617

how do I convert strtotime ("now"); to the timestamp format using PHP without inserting it into the database, if possible?

regards Jonny

[khaldryck]

use date("YmdHis"); (in PHP)
it will give you the current date formatted like the timestamp.

[jonnyb]

ok, cheers I got the newdate in the correct format now but

why doesn't this delete anything?

$date = date("YmdHis");
$seconds = 20*60;

$connect = @mysql_connect($DBhost, $DBuser, $DBpass);
$dbconnect = @mysql_select_db($DBName, $connect);

$query = "DELETE FROM $db_table WHERE 'dateAdded+$seconds'<$date";

what have I overlooked in my syntax?

JB 🙁

[khaldryck]

why don't you make a sql like this one instead ?
(i suppose you date field is called dateAdded)

$date=date("YmdHis",mktime(date("H"),date("i")-15,date("s"), date("m"), date("d"), date("Y")));
//this gives you the current date and time - 15 minutes
$query = "DELETE FROM $db_table WHERE dateAdded < $date"; 

[jonnyb]

I must be a real dope 🙂

This is my complete query, still not deleting anything

are there any issues when comparing a timestamp with date();?

my code:

<?

$DBhost = "myHost";
$DBuser = "myUsername";
$DBpass = "myPassword";
$DBtable = "myTable";

$connect = @mysql_connect($DBhost, $DBuser, $DBpass);
$dbconnect = @mysql_select_db($DBName, $connect);

$date=date("YmdHis",mktime(date("H"),date("i")-15,date("s"), date("m"), date("d"), date("Y")));//this gives you the

current date and time - 15 minutes
$query = "DELETE FROM $dbtable WHERE dateAdded < $date";

$result = mysql_query($query);

?>

[khaldryck]

the problem is the name of your variables

you declare $DBtable, but you try to delete from $dbtable

variable names are case sensitive

[jonnyb]

I am a dope...it's official

can't believe I missed that schoolboy error
thankyou for your help

all sorted now, yipppeeeee 🙂