mysq_fetch_array and MySQL "COUNT(*)"

[earswithfeet]

Hi,

what would the array look like, when i use
SELECT show_to,COUNT(*)
and get the result via $test = mysql_fetch_array?

$test["show_to"] works just fine, but how do i get the "COUNT(*)" part?

Or will i have to use $test[1], because this (s.th. like $test["COUNT"]) doesn't work?

Thanks

[earswithfeet]

DOH!

I am sorry about this.
I just saw an "as" and it the solution was more than obvious...

SELECT show_to,COUNT(*) as tmp

would then work as $test["tmp"]

Sorry,
will try to use my brain before posting in here next time 😉

[amansabharwal]

hi

Either you use "as" or use $test[1]
I don;t know any other way by which you can access this.

aman