What could this be. Is this normal. Almost in tears?

It may be food poisoning or a virus. You need to take him to a pediatrician, because in the hospital, they usually don't give the time to make an an accurate diagnosis.