echo the number of rows with the same date??

[popcop]

i have a page with a form where people submit their name and a predicted date

 

is there a way i can echo back the date that has be picked the most by the users??

 

for example if there are more rows in the database with the date of 31/07/11  i would like to echo back

 

so far people think it is going to happen on 31/07/11

 

how would i write this in php?

[AyKay47]

what I would suggest you do here is create another table with the dates chosen by users, along with the number of times that a certain date is chosen. If a date is that a user chooses is already in your database, update the row and add 1 to the number of times chosen, you can then query the date with the most predictions...