H;
eventually the Dynamic drop down menu on my search page works.


I have made a search page using two drop down and a submit button, that
populate some data from db, using DWMX and php/mysql,
it works fine, there are two things I like to find out and I need some help
if anyone can help, i am greatful for that.
first Q: how can I have a text stays on top of the drop down menu as
default and show up when page loads,( i want to do this for two of the drop down
have),
text like: <- - please select one - - >
if I put the above text inside the same table in database, I might have some
problem , becasue I want to show the data of db as DESC and then this text
will not show up that way.

on design mode, when you click on "dynamic" button while menu is selected,
there is an option of "staic option" I have inserted the above text and put
0 for value, when loading the search page in IE, it will be on dorp down
menu and it is on top as well, but it does not show up on default, dropdown
shows other item form the db,

Second Q: when viewer does not select anything from the drop down, and click
on submit button, i want an error text comes on the page ( not pop up)that says the
viewer should select something, or somethng like that.
for now if you click on submit button, the detail page opens up but of course, shows nothing .

appreciate any help;
Thanks.

Type "selected" next to the static choice
<pre id=code><font face=courier size=2 id=code>
&lt;select name="select"&gt;
&lt;option value="0" selected&gt;Please Choose&lt;/option&gt;
&lt;%
While (NOT rs.EOF)
%&gt;
&lt;option value="&lt;%=(rs.Fields.Item("YourField".Value)%&gt;"&gt;&lt;%=(rs.Fields.Item("YourField".Value)%&gt;&lt;/option&gt;
&lt;%
rs.MoveNext()
Wend
If (rs.CursorType &gt; 0) Then
rs.MoveFirst
Else
rs.Requery
End If
%&gt;
&lt;/select&gt;
</font id=code></pre id=code>


**** sorry just noticed you are PHP, but you should get the idea. Also search form validation for #2

Edited by - wdglide on 15 Mar 2003 00:59:45

Edited by - wdglide on 15 Mar 2003 01:04:52

thank you for the reply;

I have already used "selected" inside the option value command,
the text will be in drop down menu but not show up when page opens up.
it will be anther choice of drop down menu.
Thanks

I'd have to see the code...

Thank you for the reply;

here is the code for the form:

&lt;form action="yellowpage_master.php" method="post" name="searchForm" id="searchForm"&gt;
&lt;select name="Menu1" id="Menu1"&gt;
&lt;option value="0" &lt;?php if (!(strcmp(0, $row_Rs1['cat_id']))) {echo "SELECTED";} ?&gt;&gt;---Select
Category Here---&lt;/option&gt;
&lt;?php
do {
?&gt;
&lt;option value="&lt;?php echo $row_Rs1['cat_id']?&gt;"&lt;?php if (!(strcmp($row_Rs1['cat_id'], $row_Rs1['cat_id']))) {echo "SELECTED";} ?&gt;&gt;&lt;?php echo $row_Rs1['cat_name']?&gt;&lt;/option&gt;
&lt;?php
} while ($row_Rs1 = mysql_fetch_assoc($Rs1));
$rows = mysql_num_rows($Rs1);
if($rows &gt; 0) {
mysql_data_seek($Rs1, 0);
$row_Rs1 = mysql_fetch_assoc($Rs1);
}
?&gt;
&lt;/select&gt;
&lt;select name="Menu2" id="Menu2"&gt;
&lt;option value=" " &lt;?php if (!(strcmp(" ", $row_Rs2['company_name']))) {echo "SELECTED";} ?&gt;&gt;&lt;---Select
Name---&gt;&lt;/option&gt;
&lt;?php
do {
?&gt;
&lt;option value="&lt;?php echo $row_Rs2['company_name']?&gt;"&lt;?php if (!(strcmp($row_Rs2['company_name'], $row_Rs2['company_name']))) {echo "SELECTED";} ?&gt;&gt;&lt;?php echo $row_Rs2['company_name']?&gt;&lt;/option&gt;
&lt;?php
} while ($row_Rs2 = mysql_fetch_assoc($Rs2));
$rows = mysql_num_rows($Rs2);
if($rows &gt; 0) {
mysql_data_seek($Rs2, 0);
$row_Rs2 = mysql_fetch_assoc($Rs2);
}
?&gt;
&lt;/select&gt;
&lt;input type="submit" name="Submit" value="Submit"&gt;
&lt;/form&gt;

I've never PHP'd, but it looks like you have "selected" on each menu item.
try:
<pre id=code><font face=courier size=2 id=code>
&lt;option value="0" selected&gt;---Select Category Here---&lt;/option&gt;
</font id=code></pre id=code>

Edited by - wdglide on 15 Mar 2003 13:46:48