Member Avatar for buck_nakie

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 because: Fixed formatting
  • 3 Contributors
  • 3 Replies
  • 83 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Phaelax
Member Avatar for DanceInstructor

Well this line will definitly cause you some problems:

$newcount = mysql_query ("SELECT

Member Avatar for buck_nakie

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

Member Avatar for Phaelax

$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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.