PHP writing to .txt file
Posted: Mon Mar 15, 2010 7:56 am
I have a counter which takes it value from a .txt file - This value comes from the sum of a MySQL field - This script gets that value all I need to do is write it to the .txt??
<?php
// Make a MySQL Connection
$host="localhost";//hostname
$username="root";//username
$password="";//db_password
$db_name="db_name";//database name
//connect to database
mysql_connect("$host","$username","$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select database");
$query = "SELECT SUM(field) FROM table";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo $row['SUM(field)'];
echo "<br />";
}
?>
<?php
// Make a MySQL Connection
$host="localhost";//hostname
$username="root";//username
$password="";//db_password
$db_name="db_name";//database name
//connect to database
mysql_connect("$host","$username","$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select database");
$query = "SELECT SUM(field) FROM table";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo $row['SUM(field)'];
echo "<br />";
}
?>