Jump to content

echo the number of rows with the same date??


popcop

Recommended Posts

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?

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...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.