i need to NOT allow updates on my records, should the value in the [ end_on ] field be equal to or greater than todays date.

i do not have any idea how to code, i only know html and use dreamweaver as an intermediate webmaster, and i use AppGini to create php pages that connect to mysql server.

here is my php update codes, hope someone can help.. because i forgot about this one last bit of coding that would be needed for my auction project. thank you

function update($selected_id)
{
  global $HTTP_SERVER_VARS, $HTTP_GET_VARS, $HTTP_POST_VARS, $Translation;
    
    if(get_magic_quotes_gpc())
  {
           $username = addslashes($_SESSION["username"]);
            $unitrade = $HTTP_POST_VARS["unitrade"];
          $title = $HTTP_POST_VARS["title"];
                $condition = $HTTP_POST_VARS["condition"];
                $cat_value = $HTTP_POST_VARS["cat_value"];
                $price_cad = $HTTP_POST_VARS["price_cad"];
                $detail = $HTTP_POST_VARS["detail"];
              $image = $HTTP_POST_VARS["image"];
                $end_on = $HTTP_POST_VARS["end_onYear"] . '-' . $HTTP_POST_VARS["end_onMonth"] . '-' . $HTTP_POST_VARS["end_onDay"];
      }
   else
        {
           $username = addslashes($_SESSION["username"]);
            $unitrade = addslashes($HTTP_POST_VARS["unitrade"]);
              $title = addslashes($HTTP_POST_VARS["title"]);
            $condition = addslashes($HTTP_POST_VARS["condition"]);
            $cat_value = addslashes($HTTP_POST_VARS["cat_value"]);
            $price_cad = addslashes($HTTP_POST_VARS["price_cad"]);
            $detail = addslashes($HTTP_POST_VARS["detail"]);
          $image = addslashes($HTTP_POST_VARS["image"]);
            $end_on = $HTTP_POST_VARS["end_onYear"] . '-' . $HTTP_POST_VARS["end_onMonth"] . '-' . $HTTP_POST_VARS["end_onDay"];
      }

    sql("update auctions set " . "price_cad=" . (($price_cad != "") ? "'$price_cad'" : "NULL") . ", username='$username' where lot_number='$selected_id' and price_cad < $price_cad");

}

Well the first thing you would want to do is read the end_on field from the database and check it against todays date.  Then do the appropriate action from there.

Well if you can't code anything in PHP, this is gonna be hard for you.  There is no EASY way unless you can find someone to do it for you.  And this can be hard to do unless you are willing to pay for it.

Go to www.php.net and look up the command gmdate() and mktime()

I recently had the same problem trying to update logged in members at my forum and expiring them after a certain time.

From these two commands and a datetime column in your database you can achieve what is needed.

It would look similiar to;



This command will get a date from today to next month.

The next step would be to INSERT the $next_month value into the datetime column in your database.

Finally, when someone returns to your site you need to extract the datetime you inserted into the database, and compare it against todays date.


I hope this gives you some tips on how to do this.