0

Hi all,

I am learning to write with PHP and am stuck and need some wise souls help.
In a nutshell I need to be able to take grab a DB coulmn status and then count how many times it gets updated and output that number to a file and then have that number add to what the number was before. I have every thing working but getting the number. Here is the bit of code I have so far so it will be easier to figure what I need

function CountDefUpdates ()
{
//GetICMSData


UpdateICMS("UPDATE desktops SET status = \"dupend\" WHERE status = \"installed\" AND spy_policy_index = 2",$link);


$newcount = mysql_query ("SELECT


$file="count.txt";


$fh1=fopen($file,"r");
$count=fscanf($fh1,"%d");
fclose($fh1);


//echo $newcount;
//echo $count[0];


$fh=fopen($file,"w+");
$count[0]=$count[0]+$newcount;


fprintf($fh,"%d",$count[0]);
fclose($fh);

thanks for looking

Edited by Nick Evan: Fixed formatting

3
Contributors
3
Replies
4
Views
12 Years
Discussion Span
Last Post by Phaelax
0

yes that is a problem but I was removing back to $newcount=() and didn't get it all. So if anyone can help please do. If I hard code a number in there that is what gets outputted to my text file .

thank you

0

$count[0]=$count[0]+$newcount;
$newcount isn't a number, its an sql result object and therefore you cannot add objects like that together.

I'm not entirely sure what you're trying to do. Are you're trying to keep track of how many times a column is updated?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.