Calling Count column php mysql

Question

I have query that COUNT the data based from user search condition in search.

My question is just simple although I don't know what the solution here:

I want to call the COUNT column, which I know it was just temporary column I have PHP code like this:

$count = mysql_query("SELECT *, COUNT(*) AS SAMPLECOUNT FROM `subscribers` WHERE `country` = 'USA' ");
$row=mysql_fetch_array($count);

so by this code I can echo the columns inside the subscribers by using this:

echo $row['country'];
*echo the count result here*

So maybe the output will be like this:

USA: (the count result)

Problem solved I can call by using this echo $row['SAMPLECOUNT];` now I know the alias can be used as column in php — Edmhar
– Edmhar, Commented Nov 12, 2015 at 4:01
I was just going to say that ^ and wondering why you weren't using that alias. — Funk Forty Niner
– Funk Forty Niner, Commented Nov 12, 2015 at 4:03

Community · Accepted Answer · 2017-05-23 12:24:15Z

3

As requested

Since you're using an alias COUNT(*) AS SAMPLECOUNT you pass it along in the $row's array as

echo $row['SAMPLECOUNT'];

in order to show the row count's number.

Here are a few references:

Sidenote: Aliases are case-sensitive on *NIX, but not so on Windows or Mac OSX”.

So echo $row['samplecount']; could fail if on *NIX.

However and quoting this answer https://stackoverflow.com/a/2009011/ on Stack:

"On Unix, table names are case sensitive. On Windows, they are not. Fun, isn't it? Kinda like their respective file systems. Do you think it's a coincidence?

In other words, if you are planning on deploying on a Linux machine, better test your SQL against a Linux-based MySQL too, or be prepared for mysterious "table not found" errors at prod time. VMs are cheap these days.

Field names are case-insensitive regardless."

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Nov 12, 2015 at 4:09

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

vp_arth Over a year ago

You're wrong about nix/win. It's about default behavior only.

Edmhar Over a year ago

I see case sensitive.

Funk Forty Niner Over a year ago

@JJ-SAMA It could be an issue on some systems, yes.

Collectives™ on Stack Overflow

Calling Count column php mysql

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related