close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DD and Mysql Error

Thread began 12/27/2009 2:44 pm by hnewsom391969 | Last modified 1/06/2010 12:47 pm by Eric Mittman | 1108 views | 3 replies |

hnewsom391969

DD and Mysql Error

Can anyone help with this error? 0){ while($rowc = mysql_fetch_array($resc)){ echo $rowc[3]; } } ?> $

My site address is our_packages.php

The code for the DD is below:

<tr>
<td colspan="5" bgcolor="#2a2a2a" height="19"><p>
<label for="parent"></label>
<span class="Herman4">Start By Determining Your Business Here:</span></p>
<p>

<label for="child"></label>
<label for="parent2"></label>
<select name="state" id="state" >
<?
$sqlc = "select * from tbl_state order by fld_sname";
$resc = mysql_query($sqlc);
$countc = mysql_num_rows($resc);
if($countc > 0){
while($row = mysql_fetch_array($resc)){
?>
<option value="<?=$row['1']?>">
<?=$row['1']?>
</option>
<?
}
}
?>
<?php
do {
?>
<option value="<?php echo $row_Parent['fld_id']?>"><?php echo $row_Parent['fld_sname']?></option>
<?php
} while ($row_Parent = mysql_fetch_assoc($Parent));
$rows = mysql_num_rows($Parent);
if($rows > 0) {
mysql_data_seek($Parent, 0);
$row_Parent = mysql_fetch_assoc($Parent);
}
?>
</select>
<select name="bname" id="bname" >
<?
$sqlc = "select * from tbl_bname order by fld_bname";
$resc = mysql_query($sqlc);
$countc = mysql_num_rows($resc);
if($countc > 0){
while($row = mysql_fetch_array($resc)){
?>
<option value="<?=$row['1']?>">
<?=$row['1']?>
</option>
<?
}
}
?>
<?php
do {
?>
<option value="<?php echo $row_Child['fld_id']?>"><?php echo $row_Child['fld_bname']?></option>
<?php
} while ($row_Child = mysql_fetch_assoc($Child));
$rows = mysql_num_rows($Child);
if($rows > 0) {
mysql_data_seek($Child, 0);
$row_Child = mysql_fetch_assoc($Child);
}
?>
</select>

<label for="target"></label>
<input type="button" value="Add To List" id="submit1" onclick="get()"/>
<input name="remove" id="remove" onclick="WA_RemoveSelectedFromList(MM_findObj('target'),'|WA|0|WA|',-1,'0','None Selected')" value="Remove" type="button" />


<span id="status"></span>
<label for="add">$</label>

Sign in to reply to this post

Eric Mittman

I went to the link specified and the only errors that I could see reported were coming from your css files and there were some missing } curly brackets in there.

I did not see an error on your page relating to the dynamic dropdowns. Please explain a little about the steps you have taken to implement the dropdowns and the result you are getting now and if you had them working before. Also, let us know if you encounter an error exactly what the full error message is and when it occurs for you.

Sign in to reply to this post

hnewsom391969

Hi Eric,

The missing {'s was good to know. I used the assistance of another developer to recreate my site and he has the drop downs working. On the site I created, I was not able to get them to work correctly. I tried your directions alongwith an adhoc way and was not successful. I appreciate your response to this issue but you can now close this ticket. Speak to you on my next webassist project.

Sign in to reply to this post

Eric Mittman

Ok, I'm glad you were able to get the dropdowns working in some fashion. Let us know if you have any other questions or if you encounter any problems.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...