Mirge wrote:Ok don't try mine then

Sorry Mirge... I am trying everything thrown at me... I was having trouble understanding how to implement what you were explaining.
To your question.. Explain requests... Here is the structure.
request int(18) No auto_increment
req_uid varchar(41) utf8_unicode_ci No
resp_uid varchar(41) utf8_unicode_ci No
status tinyint(1) No
req_nick varchar(20) utf8_unicode_ci No
resp_nick varchar(20) utf8_unicode_ci No
time datetime No
req_image varchar(100) utf8_unicode_ci Yes NULL
resp_image varchar(100) utf8_unicode_ci Yes NULL
req_description varchar(255) utf8_unicode_ci Yes NULL
resp_description varchar(255) utf8_unicode_ci Yes NULL
If you could... Please show me how I can change my code to use your example.
Code: Select all
<?php
include 'db.php';
$time = date("YmdHis");
$requests = "UPDATE requests SET status=4 WHERE time <= ($time-864000)";
$requestsresult = mysql_query($requests)
or die("Invalid remove query: " . mysql_error());
?>
Thanks,
P