MySQL: aliased fields return value of just one field

MySQL: aliased fields return value of just one field

El Forum
Unregistered

01-30-2008, 12:37 PM

[eluser]BizComputing[/eluser]
I suspect your counts are total of fc recs.

Your joins are LEFT JOINS, so count will count NULL fp.forum_post_id's for non-hits

I seem to recall encountering this problem before, but for the life of me I can't remember how I resolved it.

Messages In This Thread

MySQL: aliased fields return value of just one field - by El Forum - 01-30-2008, 11:43 AM

MySQL: aliased fields return value of just one field - by El Forum - 01-30-2008, 12:37 PM

MySQL: aliased fields return value of just one field - by El Forum - 01-30-2008, 12:47 PM

MySQL: aliased fields return value of just one field - by El Forum - 01-30-2008, 12:59 PM

MySQL: aliased fields return value of just one field - by El Forum - 01-30-2008, 01:12 PM