Skip to main content
Participant
September 10, 2008
Question

Help list/menu update fields

  • September 10, 2008
  • 2 replies
  • 415 views
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>
This topic has been closed for replies.

2 replies

lotpbAuthor
Participant
September 24, 2008
Where in the code do I put the $_POST variable?

thanks
Inspiring
September 10, 2008
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.
lotpbAuthor
Participant
September 10, 2008
Could you please give an example of how its done