[Editing Existing Records]

Here is a small part of what I am trying to do.  When a user wants to edit their running log entries, I would like this select menu to appear with their previously selected value already selected.  Like I mentioned earlier, I don't have any problem recalling text values using value="' . $row[0] . '".  My issue is trying to figure out how to do it with select menus and/or radio menus.

         	<label for="select">Primary Terrain:</label>
		<select class="form-control" id="terrain" name="terrain_id">
            	   <option select>Select One</option>
            	   <option value="1">Asphalt (Road)</option>
            	   <option value="2">Concrete (Sidewalk)
            	   <option value="3">Crushed Gravel</option>
            	   <option value="4">Grass</option>
            	   <option value="5">Rubber Track</option>
            	   <option value="6">Trails</option>
          	</select>

[Editing Existing Records]

 

 

Thanks for responding.  Is there a way the stored values can be selected dynamically?  Is it similar to making sticky forms?

[Editing Existing Records]

I'm not sure if this is even possible but I would like to modify script 10.3.  I have created a simple running log where users can input the details of their run using a form that includes text input, radio buttons and drop-down menus.  Is it possible to use the same or similar form to edit/update their records?  I have no problem retrieving the values for the text boxes but I don't know how the form is supposed to show the values from the drop down menus or to "select" the appropriate radio button.

 

Any help would be appreciated.  Thanks!

[Multiple Calls To Mysqli_Connect.php]

Thank you for responding.  I have fixed it.

[Multiple Calls To Mysqli_Connect.php]

I am trying to create a form that includes two drop-down select menus that each display records from their respective table from a database.  Each drop-down menu uses the require statement to call my mysqli_connect script as does the overall form when it is called to insert the records, making 3 total require statements.

 

When I tested the page it worked on the testing server but now I receive Constant DB_NAME, DB_HOST, DB_PASSWORD, and DB_USER already defined errors now that the site is live.

 

I have tried using require_once on one, two , or all three calls instead of require but then one of my drop-down menus stops working and seem to get the same message.

 

Any help would be appreciated.