|
'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
if ($_POST['fromMonth'] == Null){
$_POST['fromMonth']=9;
$_POST['toMonth']=date("m");
$_POST['fromDay']=3;
$_POST['toDay']=date("d");
$_POST['fromYear']=2004;
$_POST['toYear']=date("Y");
}
?>
Largest donation: $100,000 (Thank you, Chris Weitz!)
Smallest donation: $0.50
Please note that this list is updated on a daily basis. We are working on a real-time update system which will
be implemented shortly.
Sorry, database update is in progress. Please try again later.
Null) {
$fromDateTime = $_POST['fromYear']."/".$_POST['fromMonth']."/".$_POST['fromDay']." - 00:00:00";
$toDateTime = $_POST['toYear']."/".$_POST['toMonth']."/".$_POST['toDay']." - 23:59:59";
$query="SELECT DATE_FORMAT(payment_date, '%c/%d/%y %H:%i'), Name, FORMAT(payment_amount, 0) as amountcur, payment_currency, FORMAT(ROUND(currency_rate*payment_amount), 0) as amount FROM Donation, Currency WHERE payment_currency = currency_id AND payment_date >= '$fromDateTime' AND payment_date <= '$toDateTime' ";
if ($_POST['typeOfPayment']!="all") {
$typeOfPaym=$_POST['typeOfPayment'];
$query = $query." AND '$typeOfPaym' = payment_type " ;
}
$query = $query." ORDER BY payment_date, Name";
//echo $query;
$result = mysql_query($query) or die("Query failed : " . mysql_error());
?>
|
|