i have table
table name (colddrink)
cdid, cdname, cdsize, cdprice
1 pepsi 250ml, 15
2 pepsi 1ltr 40
3 pepsi 1.5ltr 70
4 marinda 2.5ml 15
5 sprite 2.5ml 15
6 sprite 1ltr 40
now i want to display these values on webpage using datalist
like this format
pepsi
250ml, 15
1ltr 40
1.5ltr 70
marinda
250ml, 15
sprite
250ml, 15
1ltr 40
table name (colddrink)
cdid, cdname, cdsize, cdprice
1 pepsi 250ml, 15
2 pepsi 1ltr 40
3 pepsi 1.5ltr 70
4 marinda 2.5ml 15
5 sprite 2.5ml 15
6 sprite 1ltr 40
now i want to display these values on webpage using datalist
like this format
pepsi
250ml, 15
1ltr 40
1.5ltr 70
marinda
250ml, 15
sprite
250ml, 15
1ltr 40