What the heck is wrong??? (Trying to make an include file)

[swanley007]

For some reason I get zeros. Pleases help

loginc.php

<?php

function logbook_connect()
{user
	$username = "user";
	$password = "pass";
	$host = "localhost";
	$database = "test";

//Set-Up MySQL Query to select all records
	$sql = "SELECT * FROM `sheet 1` WHERE 1 ";

//Establish Connection to MySQL or Die
	$link = mysql_connect($host, $username, $password);
	if (!$link) {
 	   die('Could not connect: ' . mysql_error());
	}

//Select Correct Database or Die
	$db_selected = mysql_select_db($database, $link);
	if (!$db_selected) {
	    die ('Can\'t use test : ' . mysql_error());
	}

//Get Query Result or Die
	$result = mysql_query($sql);
	if (!$result) {
	    die('Could not query:' . mysql_error());
	}
	return $result;
}
//Functions for Each Variable Passing in $result and Returning value
function Tot_Time($result)
{
	$row = mysql_fetch_array($result);
	$Tot_Time = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Total Time
  		$Tot_Time += $row['TotalTime'];
	}
	echo "Total Time = " . $Tot_Time . "<br />";
	return $Tot_Time;

}

function Single_Engine($result)
{
	$row = mysql_fetch_array($result);
	$Single_Engine = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Single Engine
		$Single_Engine += $row['SE Land'];
	}
	return $Single_Engine;

}
function Multi_Engine($result)
{
	$row = mysql_fetch_array($result);
	$Multi_Engine = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Multi Engine
		$Multi_Engine += $row['ME Land'];
	}
	return $Multi_Engine;

}
function Night($result)
{
	$row = mysql_fetch_array($result);
	$Night = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Night
		$Night += $row['Night'];
	}
	return $Night;

}
function Cross_Country($result)
{
	$row = mysql_fetch_array($result);
	$Cross_Country = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Cross Country
		$Cross_Country += $row['XCountry'];
	}
	return $Cross_Country;

}
function PIC($result)
{
	$row = mysql_fetch_array($result);
	$PIC = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine PIC
		$PIC += $row['PIC'];
	}
	return $Cross_Country;

}
function Dual_Given($result)
{
	$row = mysql_fetch_array($result);
	$Dual_Given = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Dual Given
		$Dual_Given += $row['CFI'];
	}
	return $Dual_Given;

}
function Complex($result)
{
	$row = mysql_fetch_array($result);
	$Complex = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Complex
		$Complex += $row['Complex'];
	}
	return $Complex;

}
function Actual_Instrument($result)
{
	$row = mysql_fetch_array($result);
	$Actual_Instrument = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Actual Instrument
		$Actual_Instrument += $row['ActualInstr'];
	}
	return $Actual_Instrument;

}
function Instruction_Received($result)
{
	$row = mysql_fetch_array($result);
	$Instruction_Received = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Instruction Received
		$Instruction_Received += $row['Dual'];
	}
	return $Instruction_Received;

}
function Solo($result)
{
	$row = mysql_fetch_array($result);
	$Solo = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Solo
		$Solo += $row['Solo'];
	}
	return $Solo;

}
function X_C_Instruction($result)
{
	$row = mysql_fetch_array($result);
	$X_C_Instruction = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Croos Country Instruction Received (If X-Country >0 and Dual > 0 then Add X-Country)
		if ($row['XCountry'] > 0 && $row['Dual'] > 0)
		{
			$X_C_Instruction += $row['XCountry'];	
		}
	}
	return $X_C_Instruction;

}
function X_C_Solo($result)
{
	$row = mysql_fetch_array($result);
	$X_C_Solo = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Cross Country solo (If X-Country >0 and Solo > 0 then Add X-Country)
		if ($row['XCountry'] > 0 && $row['Solo'] > 0)
		{
			$X_C_Solo += $row['Solo'];	
		}
	}
	return $X_C_Solo;

}
function X_C_PIC($result)
{
	$row = mysql_fetch_array($result);
	$X_C_PIC = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	 for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Cross Country PIC (If X-Country >0 and PIC > 0 then Add X-Country)
		if ($row['XCountry'] > 0 && $row['PIC'] > 0)
		{
			$X_C_PIC += $row['PIC'];	
		}
	}
	return $X_C_PIC;

}
function Total_Instrument($result)
{
	$row = mysql_fetch_array($result);
	$Total_Instrument = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Total Instrument  (Total instrument = Total instrument + Simulated Instruemtnt + Actual Instrument)
		$Total_Instrument = $Total_Instrument + $row['ActualInstr'] + $row['SimInstr'];
	}
	return $Total_Instrument;

}
function Night_Instruction_Received($result)
{
	$row = mysql_fetch_array($result);
	$Night_Instruction_Received = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Night Instruction Received (If Night > 0 and Dual > 0 add Night)
		if ($row['Night'] > 0 && $row['Dual'] > 0)
		{
			$Night_Instruction_Received += $row['Night'];	
		}
	}
	return $Night_Instruction_Received;

}
function Night_TakeOff_Landings($result)
{
	$row = mysql_fetch_array($result);
	$Night_TakeOff_Landings = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Night Take-Off/Landings (Night takeoff and laonding total)
		$Night_TakeOff_Landings += $row['Night Land'];
	}
	return $Night_TakeOff_Landings;
}
function Night_PIC($result)
{
	$row = mysql_fetch_array($result);
	$Night_PIC = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Night PIC (if PIC > 0 and Night >0 add Night)
		if ($row['Night'] > 0 && $row['PIC'] > 0)
		{
			$Night_PIC += $row['Night'];
		}
	}
	return $Night_PIC;

}
function Night_TakeOff_PIC($result)
{
	$row = mysql_fetch_array($result);
	$Night_TakeOff_PIC = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine Night Take-Off PIC (Pic > 0 then aadd Takeoff)
		if ($row['Night Land'] > 0 && $row['PIC'] > 0)
		{
			$Night_TakeOff_PIC += $row['Night Land'];
		}
	}
	return $Night_TakeOff_PIC;

}
function FTD_Instruction_Received($result)
{
	$row = mysql_fetch_array($result);
	$FTD_Instruction_Received = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine FTD Instruction Received (Total FTD)
		$FTD_Instruction_Received += $row['FTD'];
	}
	return $FTD_Instruction_Received;

}
function FTD_Instrument($result)
{
	$row = mysql_fetch_array($result);
	$FTD_Instrument = 0;
	//Loop through all recors...initialize to skip first line of test/headings
	for ($i=1; $i <= mysql_num_rows($result); $i++) {
		//Determine FTD Instruction Received (Total FTD)
		$FTD_Instruction_Received += $row['FTD'];
	}
	//Determine FTD Instrument	(minus PVT Multi   Manually added number outside of loop)
	$FTD_Instrument = $FTD_Instruction_Received - 6.5;
	return $FTD_Instrument;
}


?>

The calling page, testfunct.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
include 'loginc.php';

$result = logbook_connect();
echo Tot_Time($result) . "<br />";
echo Single_Engine($result) . "<br />";
echo Multi_Engine($result) . "<br />";
echo Night($result) . "<br />";
echo Cross_Country($result) . "<br />";
echo PIC($result) . "<br />";
echo Dual_Given($result) . "<br />";
echo Complex($result) . "<br />";
echo Actual_Instrument($result) . "<br />";
echo Instruction_Received($result) . "<br />";
echo Solo($result) . "<br />";
echo X_C_Instruction($result) . "<br />";
echo X_C_Solo($result) . "<br />";
echo X_C_PIC($result) . "<br />";
echo Total_Instrument($result) . "<br />";
echo Night_Instruction_Received($result) . "<br />";
echo Night_TakeOff_Landings($result) . "<br />";
echo Night_TakeOff_PIC($result) . "<br />";
echo FTD_Instruction_Received($result) . "<br />";
echo FTD_Instrument($result) . "<br />";
?>
</body>
</html>

Any Help would be great!!! Thanks!

[messels]

have you tested your functions one at a time? like, did you verify that your connecting to the db? personally i find it easier to set the db info in one file "databaseinfo.inc.php" for example and then include that file as needed.

anyway, this looks weird to me:
//Set-Up MySQL Query to select all records
$sql = "SELECT * FROM sheet 1 WHERE 1 ";

WHERE 1? wtf is that? is it suppose to be "WHERE sheet 1 = 1? anyway, doens't look syntactically correct.

what happens if you do "SELECT * FROM sheet 1"? do you get results?
it also doesn't look like ever return any data either. that's probably the problem. you need to set the db results to something. right now, it's just set to return a "true" or "false" answer. (0 or 1). so maybe setup a "

while ($results = mysql_fetch_array ($query, MYSQL_ASSOC)) { $query_results = $results ['sheet 1']; } 

also, never include db password info in your posts. just not a good idea. i would edit your post [NOW] and take out hte password...that's just me though.

[swanley007]

I do not have the ability to edit post, the $sql query is what came from NaviCat to use. I will try the loop to pull out the results though...