hmm i found something else out, the php file that comes with the package already has an odbc_connect thing in it, all I need to know is how to make a access database, because it asks me for that.... here you go here is the code and look at the @define part
<?php
/*
* You may not remove this header!
*
* **********************************************************************************************************************************
* 'pilot_roster.php' script code was made by Paulo Correia - FSAcars Team (©)2003
* It's part of the FSAcars 2 for VA's package
*
* This script assumes that the VA has has PHP support and a MSAccess database on it's site
*
* A sample MSAccess file with the following tables is provided: 'Pilots', 'Reports'
* **********************************************************************************************************************************
*
* FSACARS is distributed freely.
*
* Disclaimer
* Although this product has been intensively tested, the authors accepts no responsibility for any damages caused by the use or misuse of this
* software. This software is distributed 'as is' with no warranty expressed or implied. The authors will not be responsible for any losses incurred, either directly or indirectly, by the use of this software.
* Use this software entirely at your own risk. If you do not agree to these terms then you must not use this software.
*
* Copyright
* This software is a copyrighted program. AIBridge is a copyright of José Oliveira. FSACARS coding is a copyright of José Oliveira. FSACARS concept was idealized by Pedro Sousa.
* It is protected by international copyright laws.
*/
/*
* Change this constants according to your configuration */
@define (ACCESS_ODBC, ""); // Access database odbc
@define (ACCESS_DB_USER, ""); // Access database user
@define (ACCESS_DB_PASSWORD, ""); // Access database password
/* Database connection */
$conn = odbc_connect(ACCESS_ODBC,ACCESS_DB_USER,ACCESS_DB_PASSWORD);
if ($conn) {
/* Select pilot's */
$stmt = "SELECT * FROM Pilots ORDER BY PilotID";
$result=odbc_exec($conn,$stmt);
if ($result) {
while (odbc_fetch_row($result)) {
/* Print roster header
Change this HTML to fit your webpage layout */
print "<table>";
print "<tr>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>NUMBER</b></font></td>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>NAME</b></font></td>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>CITY</b></font></td>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>COUNTRY</b></font></td>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>FLIGHT TIME</b></font></td>";
print "<td bgcolor=#000080 width=73 height=12 align=left><font face=Arial color=#FFFFFF size=1><b>STATUS</b></font></td>";
print "</tr>";
$c1 = odbc_result($result, "PilotID");
$c2 = odbc_result($result, "Name");
$c3 = odbc_result($result, "City");
$c4 = odbc_result($result, "Country");
$c5 = odbc_result($result, "Status");
/* Calculate pilot's total time */
$stmt = "SELECT SUM(t2.total) AS Minutes FROM Pilots t1, Reports t2 WHERE t1.PilotID = '$c1' AND t1.ID = t2.pilot_id;";
$result=odbc_exec($conn,$stmt);
if ($result) {
/* Convert minutes to hh:mm */
$total = odbc_result($result, "Minutes");
$h = (int)($total/60);
$m = round((($total/60) - $h) * 60);
if ($m < 10) {
$m = "0".$m;
}
$p3 = $h."h".$m."m";
} else {
$p3 = "N/A";
}
/* Display roster entries */
print "<tr>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$c1</font></td>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$c2</font></td>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$c3</font></td>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$c4</font></td>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$p3</font></td>";
print "<td width=73 height=12 align=left><font face=Arial size=1 color=#000080>$c5</font></td>";
print "</tr>";
}
print "</table>";
}
/* Print table footer - DO NOT REMOVE */
print "<table>";
print "<tr><td><font face=Arial size=1 color=gray>Powered by FSACARS for VA's - http://www.satavirtual.org/fsacars/</font></td></tr>";
print "</table>";
/* Close Connection */
odbc_close($conn);
}
?>
