"b" . $year,
// 'month' => $month,
// 'day' => $day) ;
return "the date is" . date('m-d-y',mktime(0,0,0,$month,$day,$year));
} else {
return array(
'year' => $year,
'month' => $month,
'day' => $day); // date out of range
} // end if
} // end datecheck
function escape_data($data) { // Create a function to escape the data
global $dbConn; //Need the connection
if (ini_get('magic_quotes_gpc')) {
$data = stripslashes($data);
}
return mysql_real_escape_string($data, $dbConn);
} //end escape_data function
function connectPace() {
// conncet to Pace db
global $serverName, $userName, $password;
//$dbConn = mysql_connect($serverName, $userName, $password);
$dbConn = mysql_connect($serverName, $userName, $password);
if (!$dbConn) {
print "
Problem connecting to database!
\n";
} // end if
$select = mysql_select_db("theffron_PACE");
if (!$select) {
print mysql_error() . " \n";
} // end if
return $dbConn;
} // end connectPace
function buildFieldList($tablename, $selectname, $keyname, $keyVal, $fieldname, $addNone) {
// with a given table and field generate list values for an HTML select
global $dbConn;
$output = "";
$sqlquery = "select $keyname, $fieldname from $tablename order by $fieldname asc";
$result = mysql_query($sqlquery, $dbConn);
$output .= "