popcop

the html of the screen shot i posted?

Hi guys im new to PHP and im trying to pick up as much as i can as quickly as possible ive used a form to submit data to the database and now i want to pull that data and display it on a page. Ive attached an image of what the final page will look like. i just need to know how i will go about getttin that information out of the DB and onto the page in the way that i want it i also want to display it in rows which have alternate colours, and also be able to click the buttons on left hand side to split the results into the appropriate months hope you can help

excellent, that worked thank you

should my field type be DATE in the database? im gettina little confused. this is the return of whats being send to the DB from the form Array ( [firstname] => hhh [lastname] => lll => gerrymckay@live.com [date] => 08/25/2011 ) Database updated with:hhhlllgerrymckay@live.com from what youve said, i need to change the format to YYYYMMDD before the database will accept it. im not 100% sure where to change this

could you maybe show me how i could do this as im kinda new to php

ive not done anything really i just create the row for date am trying to send it from the form ive added print_r($_POST); to my page to see whats actually being send over and this is the resuts Array ( [firstname] => tom [lastname] => mckay => tom@gmail.com [date] => 07/20/2011 ) Database updated with:tommckaytom@gmail.com do i need to change anything in the actually DB?? or from the form?? Im actually wanting the date to be sent in this format for example Saturday 30th July 2011 so that i can pull if from the database and display it on the page in that format

im using the jquery UI datepicker to submit a date to my database but i keep storing 0000-00-00 instead of the date anyone know why this would be happening?