How do I call this function

[Dethman]

it is for a Cron and I dont even know if it is Correct I need to -1 from the Row PPT in SQL when it is called and I was told it isnt calling

 

function deductPPT($id){
if($user['PPT']>=1){
$q="UPDATE `user_users` SET `PPT` =`PPT` - 1 WHERE `userid` = '$id'";
}
}

 

Any Help would be great Dethman

[PHP Monkeh]

Where is $user['PPT'] coming from?  And if you wanted the query to run you still haven't executed mysql_query()

[Dethman]

Can you tell me how to Execute it?

[PHP Monkeh]

<?php
function deductPPT($id){
if($user['PPT']>=1){
$q="UPDATE `user_users` SET `PPT` =`PPT` - 1 WHERE `userid` = '$id'";
mysql_query($q) or die(mysql_error());
}
}
?>

[rhodesa]

Yeah...but $user is still coming out of no where. Is this a variable you set before calling the function?

 

I'm gonna throw out a guess, and assume you are trying to decrease the value of PPT by 1 for a specific user in the table, unless PPT is less then or equal to 1. If so, this is what you want:

 

<?php
function deductPPT($id){
  $q = "UPDATE `user_users` SET `PPT` =`PPT` - 1 WHERE `userid` = '$id' AND `PPT` > 1";
  mysql_query($q) or die(mysql_error());
}
?>