MySQLi version of a Dynamic Dropdown on an UPDATE form?

7/22/2015 9:16 am | #1 Nathon Jones Web Design

So when I try to select "Dynamic" for my dropdown menu, in my update form, the MySQLi recordset doesn't show as available. So, I created 2 recordsets - one MySQL, one MySQLi - and I the non-MySQLi recordset is available which, for my select field, gives me this:

<select class="form-control" id="BWnewsbutton" name="BWnewsbutton" tabindex="6">
                        	  <option value="1" <?php if (!(strcmp(1, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Contact Page</option>
                        	  <option value="2" <?php if (!(strcmp(2, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Windows Page</option>
                        	  <option value="3" <?php if (!(strcmp(3, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Doors Page</option>
                        	  <option value="4" <?php if (!(strcmp(4, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Conservatories Page</option>
                        	  <option value="5" <?php if (!(strcmp(5, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Get a Quote - Windows</option>
                        	  <option value="6" <?php if (!(strcmp(6, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Get a Quote - Doors</option>
                        	  <option value="7" <?php if (!(strcmp(7, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Get a Quote - Conservatories</option>
                        	  <option value="8" <?php if (!(strcmp(8, $row_rsEDITNEWSalt['BWnewsbutton']))) {echo "selected=\"selected\"";} ?>>Home Page</option>
                            </select>

Rather than have two recordsets on the page, where only one is required, what is the MySQLi version of the above?
Thank you.
NJ

7/23/2015 10:47 am | #2 Ray BorduinWebAssist

Just replace:
$row_rsEDITNEWSalt['BWnewsbutton']

with:
$MySQLiRecordsetName->getColumnVal('BWnewsbutton')

everywhere it appears in that code chunk.

Did this help? Tips are appreciated...

8/27/2015 2:08 pm | #3 Nathon Jones Web Design

Thank you Ray.

is there a way to drop this into a repeat region? I've tried the following but, whilst it does give me a dynamic list it auto loads on the last value:

<?php
while(!$rsDISTILLERY->atEnd()) {
?>
<option value="<?php echo($rsDISTILLERY->getColumnVal("wbprodDISTID")); ?>" <?php if (!(strcmp($rsDISTILLERY->getColumnVal("wbprodDISTID"), $rsDISTILLERY->getColumnVal("wbprodDISTID")))) {echo "selected=\"selected\"";} ?>><?php echo($rsDISTILLERY->getColumnVal("wbprodDISTILLERY")); ?></option>
                                  <?php
  $rsDISTILLERY->moveNext();
}
$rsDISTILLERY->moveFirst(); //return RS to first record
?>

8/27/2015 2:29 pm | #4 Ray BorduinWebAssist

In the code that sets the selection you are comparing the value to itself:

<?php if (!(strcmp($rsDISTILLERY->getColumnVal("wbprodDISTID"), $rsDISTILLERY->getColumnVal("wbprodDISTID")))) {echo "selected=\"selected\"";} ?>

one of those two recordsets should be the updated recordset used to populate the form and not the repeated one.

Did this help? Tips are appreciated...

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

MySQLi version of a Dynamic Dropdown on an UPDATE form?

7/22/2015 9:16 am | #1 Nathon Jones Web Design