using a sql I get the following data
no-1
fromdate :01/01/2002
todate :31/01/2002
fromday : sun
today :thu
price :100
This data needs to be converted to the following
no-1
fromdate :01/01/2002
todate :31/01/2002
sun :100
mon :100
tue :100
wed :100
thu :100
fri :0
sat :0
can anyone help me do this. Very urgent
