comma in mysql database...retrieving sizes....

[cloudseven]

hi there, I am working on an e-commerce site and I have different sizes for a line of clothing. Instead of adding different fields for S,M,L. I would like to just add one field that contains all the sizes separated by commas. I don't know how to retrieve it from the database into a selectbox when there are commas in that field. What function do I use to look for the comma? Thanks in advance!

 

[GaryC123]

Personally I would stick to the fields but anyway...

Grab the recordset from the DB then use

Sizes=Split(RS("sizesfieldname&quot,",&quot
' this splits the field into an array called sizes

<select name=&quot;&quot;>
<%
for i = 0 to ubound(sizes)
response.write&quot;<option>&quot; & sizes(i) & &quot;</option>
next
%>
</select>

http://www.intouch-media.co.uk

 

[cloudseven]

hey gary, yeh usually I use separate fields but I wanted to try another way...thanks a bunch!