944,022 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 1743
  • PHP RSS
Apr 16th, 2005
0

New to PHP and MySQL and help bad!

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
buck_nakie is offline Offline
3 posts
since Apr 2005
Apr 16th, 2005
0

Re: New to PHP and MySQL and help bad!

Well this line will definitly cause you some problems:

$newcount = mysql_query ("SELECT
Reputation Points: 17
Solved Threads: 14
Posting Whiz
DanceInstructor is offline Offline
355 posts
since Feb 2005
Apr 16th, 2005
0

Re: New to PHP and MySQL and help bad!

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
buck_nakie is offline Offline
3 posts
since Apr 2005
Apr 17th, 2005
0

Re: New to PHP and MySQL and help bad!

$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?
Reputation Points: 92
Solved Threads: 51
Practically a Posting Shark
Phaelax is offline Offline
856 posts
since Mar 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Whats wrong with this code
Next Thread in PHP Forum Timeline: Contribute code





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC