stupid query

[otuatail]

cant get simple query to return anything. The querry when used in mysql via phpmyadmin returns 276

 

$sqlhits = "select count(EventID) FROM EventLog AS Count WHERE Hit = 'Y'";

$rsHits = mysql_query($sqlhits);

$Item = mysql_fetch_array($rsHits);

echo $Item['Count'];

 

retuns blank

 

[otuatail]

This does work  $Item[0];

This dosn't $Item['Count'];

[Loldongs]

do print_r($Item);

[GingerRobot]

That would be because there isn't a row in your result set called Count. You're using an alias on the table name rather than the selected row.

 

$sqlhits = "select count(EventID) as Count FROM EventLog WHERE Hit = 'Y'";

[otuatail]

If I use an  Alias then that should be returned. It works in sql server also if I run the query in Mysql Admin

it shows the result under the Alias name. You should be able to use an alias for any columb name.

 

 

[craygo]

you can use an alias for any column name but depends where you put it. you put Count in your FROM clause so you are giving the alias to your table not your column. If you had 2 tables with the same column name your query would fail. In phpmyadmin it should actually show count(Eventid) so if you wanted to return it in php it would be

$Item['count(Eventid)']

 

All aliases for column names should be in the SELECT clause.

 

Ray