All pastes #19518 Raw Edit

Mine

public text v1 · immutable
#19518 ·published 2005-08-07 18:56 UTC
rendered paste body
<?php
require_once('admin_sql.php');

$q=mssql_query("SELECT     *
FROM         MEMB_INFO
WHERE     (contribui_data > 0)
ORDER BY contribui_data");
/*
while ($s=mssql_fetch_array($q))
{
	// Data
	$d=date('d',$s[contribui_data]);
	$m=date('m',$s[contribui_data]);
	$Y=date('Y',$s[contribui_data]);

	// Montando array
	$cont[$d][$m][$y]=$cont[$d][$m][$y]+0;
	//echo date('d-m-Y',$s[contribui_data]);exit;
}

echo $cont[19][07][2005];
echo '<br>'.count($cont);
*/
$i=0;
while ($s=mssql_fetch_array($q))
{
	if ($data[$i-1]!=date('d-m-Y',$s[contribui_data]))
	{
		$i++;
		$qtd[$i]++;
		$data[$i]=date('d-m-Y',$s[contribui_data]);
	}
	else
	{
		$qtd[$i]++;
		$data[$i]=date('d-m-Y',$s[contribui_data]);
	}
	echo date('d-m-Y',$s[contribui_data]).'<br>';
}

echo 'Data;Qtd<br>';

for ($i=0;$i<count($qtd);$i++)
	echo $data[$i].';'.$qtd[$i].'<br>';
	

?>