need help placing mysql statement into php

[pantalion]

mysql statment:

SELECT SUM (flyeramount) total_flyers
FROM summerflyer;

now I need to put this into my document.php, can anyone help? i tried:

<? $query = "SELECT SUM flyeramount FROM summerflyer";
$result = mysql_query ($total_flyers); ?>

and then put the following into my page for it to echo:

<?php echo $totalflyers ?>

but nothing happens, any help would be greatly appreciated!!!!

[laserlight]

SQL isnt my strong point, so I'm not too sure on the sum thing, but:

<?php
$query = "SELECT SUM(flyeramount) AS flyersum FROM summerflyer";
$result = mysql_query($query)
	OR die(mysql_error());

$row = mysql_fetch_assoc($result);

echo $row['flyersum'];
?>

If it doesnt work you'll need someone who's good at SQL to write the correct SQL statement for you and use PHP with it.

Generally, the most obvious mistake (to me) was that $total_flyers is not defined, so
$result = mysql_query ($total_flyers);
is fairly pointless

[kevinsequeira]

read up on some tutorials on php. this is how u would execute a query using php

<? 
// connect to database first
mysql_connect("host","username","password");
//select database
mysql_select_db("database");
// generate the query
$query = "SELECT SUM(flyeramount) FROM summerflyer";
// execute the query
$result = mysql_query($query);
//check for error
if(mysql_error()){
 echo mysql_error();
  exit;
}else{
// if no error get the resultset
 $row = mysql_fetch_array($result);
// echo the resultset first row's first element
  echo "total = ".$row[0];
}
//close the connection to the db
mysql_close();
?>

reg
kevin

[cahva]

It should be:

$query = "SELECT SUM(flyeramount) FROM summerflyer"; 
$result = mysql_query ($query); 

And if you want to print it afterwards:

$totalflyers=mysql_result($result,0);
echo $totalflyers;