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? Quote 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... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.