popcop Posted August 1, 2011 Share Posted August 1, 2011 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? Link to comment https://forums.phpfreaks.com/topic/243420-echo-the-number-of-rows-with-the-same-date/ Share on other sites More sharing options...
AyKay47 Posted August 1, 2011 Share Posted August 1, 2011 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... Link to comment https://forums.phpfreaks.com/topic/243420-echo-the-number-of-rows-with-the-same-date/#findComment-1249992 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.