0
Help list/menu update fields
New Here
,
/t5/dreamweaver-discussions/help-list-menu-update-fields/td-p/89296
Sep 10, 2008
Sep 10, 2008
Copy link to clipboard
Copied
I am trying to update 3 field when I pick field from
List/menu please help how to do this
code below
<select name="LookupLeadNo" id="LookupLeadNo">
<?php
do {
?>
<option value="<?php echo $row_fmLeads['LeadNo']?>"<?php if (!(strcmp($row_fmLeads['LeadNo'], $row_fmcustomer['LeadNo']))) {echo "selected=\"selected\"";} ?>><?php echo $row_fmLeads['Last Name']?></option>
<?php
} while ($row_fmLeads = mysql_fetch_assoc($fmLeads));
$rows = mysql_num_rows($fmLeads);
if($rows > 0) {
mysql_data_seek($fmLeads, 0);
$row_fmLeads = mysql_fetch_assoc($fmLeads);
}
?>
</select>
code below
<select name="LookupLeadNo" id="LookupLeadNo">
<?php
do {
?>
<option value="<?php echo $row_fmLeads['LeadNo']?>"<?php if (!(strcmp($row_fmLeads['LeadNo'], $row_fmcustomer['LeadNo']))) {echo "selected=\"selected\"";} ?>><?php echo $row_fmLeads['Last Name']?></option>
<?php
} while ($row_fmLeads = mysql_fetch_assoc($fmLeads));
$rows = mysql_num_rows($fmLeads);
if($rows > 0) {
mysql_data_seek($fmLeads, 0);
$row_fmLeads = mysql_fetch_assoc($fmLeads);
}
?>
</select>
TOPICS
Server side applications
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Engaged
,
/t5/dreamweaver-discussions/help-list-menu-update-fields/m-p/89297#M135239
Sep 10, 2008
Sep 10, 2008
Copy link to clipboard
Copied
Do you really need them shown? - i.e. a refresh?
or are you just looking to update 3 fields in the database?
If you are looking to update the database, you can use the $_POST variable to insert into as many fields in the record as you want. But his would be done in the MySQL statement, not the form.
or are you just looking to update 3 fields in the database?
If you are looking to update the database, you can use the $_POST variable to insert into as many fields in the record as you want. But his would be done in the MySQL statement, not the form.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
lotpb
AUTHOR
New Here
,
/t5/dreamweaver-discussions/help-list-menu-update-fields/m-p/89298#M135240
Sep 10, 2008
Sep 10, 2008
Copy link to clipboard
Copied
Could you please give an example of how its done
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
lotpb
AUTHOR
New Here
,
LATEST
/t5/dreamweaver-discussions/help-list-menu-update-fields/m-p/89299#M135241
Sep 24, 2008
Sep 24, 2008
Copy link to clipboard
Copied
Where in the code do I put the $_POST variable?
thanks
thanks
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

