Unable to echo count result

[Anonymous]

Hello again. Count causing me a headache at the moment.

I'm calling up values from a table and groouping and counting them but am unable to reference the column the query creates called "Count(*)".

The part of the code that's causing the issue lies below:

while($result = mysql_fetch_array($RecordCount04))
{
echo "<tr>";
echo "<td width='300'>$result[ReqURI]</td>";
echo "<td>$result[Count]</td>";
echo "</tr>";
}

The ReqURI echoes quite nicely but not the count. I've tried Count(*) and COUNT\(\*\) but no juice.

Any suggestions...?

 

[Anonymous]

can you post your query ...
it would be easier to understand

 

[Anonymous]

ruturajv

I managed to resolve this by renaming the column through the query's select X as Y option.

Many thanks for your time though :-D