php page

[FredFlint]

Hi,
Am trying to create a basic web page to display some sales data from a MS SQL database. All the SQL work is done in a stored procedure that looks like:
sp_ATP_Get_All_OutletDayTransation @StartDate datetime, @MoDe int, @clear bit = 0
All the page needs is a date time picker and a refresh button that populates a table on the web page but I don’t normally do web stuff so am having a hard time. Also I am using notpad so there is no syntax checking.
Any help or pointers would be greatly appreciated.

thanks.

 

[Redrum]

What part are you struggling with? If it's the date and time picker, take a look at some of the freely available ones out there, like this.

 

[FredFlint]

What part are you struggling with? If it's the date and time picker, take a look at some of the freely available ones out there, like this.

After a bit of work I got some of it working but not having an ide was a nightmare so I tried using visual studio mvc4 and got it done. I still have to work out how to pass params to the stored procedure and sort out a datetime picker.

Thanks for the link hopefully they will work in asp.