A Voting System Help 2

[perlone]

Hello,

I'm creating a voting system and I was wondering if you could help me. I have 2 columns - gid,IP. `gid` is the ID for game and `IP` is for IP Address.

gid | IP
6 |xx.xxx.xx
7 |xx.xxx.xx
6 |xx.xxx.xx
6 |xx.xxx.xx

I want to display the results like this:

GID | Votes
6 | 3
7 | 1

As you can see, it counts how many votes each has. Does anyone knows how to do this? Thank You.

 

[sleipnir214]

Given a table foo containing:

+------+---------+
| gid  | ip      |
+------+---------+
|    6 | 1.2.3.4 |
|    7 | 2.3.4.5 |
|    6 | 3.4.5.6 |
|    6 | 4.5.6.7 |
+------+---------+

The query

select gid, count(gid) as votes from foo group by gid;

will return:

+------+-------+
| gid  | votes |
+------+-------+
|    6 |     3 |
|    7 |     1 |
+------+-------+

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[perlone]

Thank You!

 

[perlone]

Hi,

I'm using phpMyAdmin and what 'type' of feld do you think IP address should hold? So far I have 'TEXT'. Is this ok? Thanks.

 

[danielhozac]

Depends on what you'll be using it for. Most likely though, is that you'd want it to be varchar(15).

//Daniel

 

[perlone]

Thank You. I was thinking about varchar(15) too.