Mysql COUNT doesn't add all names

[mikeabe]

Can you help me with this?

When i run this SQL command in phpMyAdmin:

select student, count(student) from incoming group by student;

 

Some kids names are counted correctly, others are shown twice. For example:

2 Angel Cesar

3 Angel Cesar

 

Why would I not get:

5 Angel Cesar

 

All the names are fed to Mysql from a php web form drop-down list, so there isn't any possibility of the names being spelled differently.

 

Thanks, Mike

[revraz]

Does this work?

 

SELECT count(*), student FROM incoming GROUP BY student;

 

 

[mikeabe]

Thanks for the response.

I copied and pasted your code into Mysql, but i got the same result as before. Wierd how it's working.

[PFMaBiSmAd]

You probably have some white-space before or after the names. You would need to dump the data and examine it or check what the length is.

 

If you do have some white-space, it is probably due to a coding error when the names were entered or when they are being put into the form.

[mikeabe]

Thanks. I'll check that out and let you know what i find.

[xtopolis]

It looks like he's trying to SUM() a column, not count the affected rows if he expects the result of 5 from his first post?

[revraz]

SUM adds the values in the fields, not how many iterations there are.

 

What he is saying is that it shows 2 Angels and 3 Angels instead of 5 Angels, which means the Values are different somehow.

[mikeabe]

This is what's going on:

 

The teachers submit tardies with a php/html web form.

The data is sent to mysql.

 

I'm trying to make a form that will tell the teachers who is getting the most tardies.

 

the web form they see looks something like this:

 

 

tardies    student

4            campa myrea

4            delgado juan

3          anguiano maria

1          gerardo jose

1          archuletta david

 

 

kids are ordered by tardies.

So campa myrea has 4 tardies, and so on. And the teacher can see her individual tardies with dates, etc. on another form.

the form works fine for MOST kids

 

but some kids names look like this:

 

2          ramirez jennifer

2          ramirez jennifer

 

and her name should be

 

4        ramirez jennifer

 

 

I'm in the process of dumping data and submitting it again to see what happens.

 

This is an intranet. I host everything from my computer.

Thanks, Mike

[revraz]

The best way to do this is use an ID for the students, then count the IDs instead.  This will ensure there is only 1 name per ID.

[mikeabe]

I'll try that.

 

Thanks, Mike