sql via cron

[alexhigh]

Finally worked it out

stockupdate.php:

// your code to run via cron 
// Updates stock
<?php
include("db.php");

mysql_connect($dbhost, $dbuser, $dbpass) or die("CANNOT CONNECT TO DB-HOST");
    mysql_select_db($dbname) or die("DATABASE NAME PROBLEM");
    
    $sql = "UPDATE products SET products_status = 1 WHERE products_quantity >= 3"; 
    mysql_query($sql) or die("SQL ERROR:<hr>".$sql);
    
    $sql = "UPDATE products SET products_status = 0 WHERE products_quantity <= 2"; 
    mysql_query($sql) or die("SQL ERROR:<hr>".$sql);
    
    $sql = "UPDATE products SET products_price = products_price *1.25 WHERE master_categories_id = 112"; 
    mysql_query($sql) or die("SQL ERROR:<hr>".$sql);
?>

db.php:

<?php
//DATABASE
//EDIT ONLY BETWEEN QUOTES

$dbhost="localhost";            // YOUR HOST NAME USUALLY LOCALHOST
$dbuser="username";     // YOUR DATA BASE USER NAME USUALLY ROOT
$dbpass="pass";                 // YOUR DATA BASE PASSWORD
$dbname="databasename";   // YOUR DATA BASE NAME
?>

[kobra]

php /home/trymarket/public_html/admin/stockupdate.php

Secure your site NOW!!!
http://www.zen-cart.com/forum/forumdisplay.php?f=134

[alexhigh]

It's ok Kobra I just named my admin area like that as an example, its not really called that

[AndyVI]

I need a similar mod to this but based on price range markup

for example:

£0 - £20 = 10%
£21 - £30 = 15%
£31 - £100 = 20%

How would I go about defining a price range and % for each?

Many Thanks in advance..