Quick select query question

[golfinggod]

Hi

Just a quick question, would it work if used this date format

date ("m")

as a where factor when surching for reports. Ie

Get todays month

 $month = date("m")

$Selectid2 = "SELECT Username, count(*) FROM bannerdisplays WHERE Username = '$Username' & Date = '$month' GROUP BY Username";   

	$result = mysql_query ($Selectid2); 
	

Would this work in generating all the reports from the given month.

Cheers 🙂

[xDeadxBeatx]

Have you tested the script yet. Test it but change this line:

$result = mysql_query ($Selectid2);

to this:

$result = mysql_query ($Selectid2) or die (mysql_error());