Getting no value from query no error show

[qadeer_ahmad]

Dear Friends ,

My query working and no error show but i do not get any value from my query please check it and guid me

<?php
$query2="SELECT sum(p.revised) as units,p.customer as customer,x.speciecode as speciecode
FROM slproj p
LEFT OUTER JOIN crxref x ON ( x.item = p.item AND x.customer = p.customer )
WHERE p.customer='$custno' AND p.pdate
BETWEEN '$date1' AND '$date2'
GROUP BY p.customer,x.speciecode";
$rquery2=mysql_query($query2);

	while($qrow2=mysql_fetch_array($rquery2))
	{
	$units=$qrow2['Units'];
	//$budgettotal=$qrow5['BudgetTotal'];
	print $units."Special units total<br>";
	//print $budgettotal."budjet total<br>";

	}

?>

[TheDefender]

The index name is case sensitive:

<?php 
$query2="SELECT sum(p.revised) as units,p.customer as customer,x.speciecode as speciecode 
FROM slproj p 
LEFT OUTER JOIN crxref x ON ( x.item = p.item AND x.customer = p.customer ) 
WHERE p.customer='$custno' AND p.pdate 
BETWEEN '$date1' AND '$date2' 
GROUP BY p.customer,x.speciecode"; 
$rquery2=mysql_query($query2); 

while($qrow2=mysql_fetch_array($rquery2)) 
{ 
$units=$qrow2['units']; // changed to match the qry definition of the index name. 
//$budgettotal=$qrow5['BudgetTotal']; 
print $units."Special units total<br>"; 
//print $budgettotal."budjet total<br>"; 

} 
?>