sql via cron

[alexhigh]

Hi, I'm not sure whether this is the best section to ask about this but here we go anyway..

I'm trying to automatically mark a range of products as out of stock, when I run this via 'Install SQL Patches' everything works great:

UPDATE products SET products_status = 1 WHERE products_quantity >= 3;
UPDATE products SET products_status = 0 WHERE products_quantity <= 2;

What I'm trying to work out is how I would go about running an SQL query via a cron job. This is how I have the command in CPanel:

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

and this is stockupdate.php:

// filename: stockupdate.php
// make changes in /admin/init_includes/init_admin_auth.php
if ($_SERVER['REMOTE_ADDR'] == $_SERVER['SERVER_ADDR']) {
define('CRON_ADMIN_USER_ID', '99');
}

// your code to run via cron 
// Updates stock

$sql="UPDATE products SET products_status = 1 WHERE products_quantity >= 3";
$sql="UPDATE products SET products_status = 0 WHERE products_quantity <= 2"; 

Unfortunately this is not working and am pretty certain it's to do with the way I've set up the SQL functions in my php script. If someone could help me with this it would no-doubt also help me with another SQL query I'm hoping to run via cron job, which is along these lines for marking up product prices:

UPDATE products SET products_price = products_price *1.25 WHERE master_categories_id = 32;

Any help with this would be appreciated ;-)

[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..