Hi,

I created a link column: mem_interval. Default i didn't put any.

------------------------

mem_interval (Column Name)
ENUM
None

--- (Column Values)
Daily
Weekly
Biweekly

Not Null Yes

mem interval (Form Display)

SELECT (Form Type)

--- (Form Names)
Daily
Weekly
Biweekly

--- (Form Values)
Daily
Weekly
Biweekly

------------------------

I created a drop downlist like in include_form.html:

<SELECT NAME="mem_interval" SIZE="1">
<OPTION VALUE="---">---</OPTION>
<OPTION VALUE="Daily">Daily</OPTION>
<OPTION VALUE="Weekly">Weekly</OPTION>
<OPTION VALUE="Biweekly">Biweekly</OPTION></SELECT>

My questions are:

1. I put this tag in detailed page:

<%if mem_interval%><%d_font%>Member Interval:</font> <%body_font%><%mem_interval%></font><%endif%>

Now on the every detailed page showing Member interval: ---

I want the mem_interval displayed only when Daily,weekly,biweekly are selected. If it is --- , i don't want the Member interval tag displayed on detailed page.

How?

Thanks.

Hi,

1. What is the difference between

ENUM(---, Yes, No)

AND

ENUM(Yes, No)

for Column Values, Form Names, Form Values if i didn't enter anything in 'default' textbox?

2. First i set like ENUM(Yes, No). All links get 'Yes' entered for this colum. So i changed it to ENUM(---, Yes, No). Even now the link columns showing 'Yes' instead of '---' How to change it?

The column Not null set to No.

3. On detailed page i set this tag:

<%if Free_Ads%><%d_font%>Free ads:</font><%body_font%><%Free_Ads%></font><%endif%>

Every link on detailed page showing 'Yes'.

Can i keep like this on detailed page:

<%if Free_Ads == ---%><%d_font%>Free ads:</font><%body_font%>---</font><%else%><%body_font%><%Free_Ads%></font><%endif%>

Thanks.