[SOLVED] Pre-filling Forms with Database Information

[virtuexru]

OK. I have an update record form I'm building. I can pre-fill the text fields, but have no idea how to pre-file the drop down fields?

 

For example:

 

        <?php
        $query  = "SELECT * FROM vehicles WHERE veh_id = '$id' LIMIT 1";

        $result = mysql_query($query) or die(mysql_error());
        while($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
        ?>
            // KNOW HOW TO PRE-FILL
            <tr bgcolor="#E9E9E9">
            	<td style="padding-left: 5px;"><strong>Model:</strong></td>
                <td><input type="text" name="_model" value="<?php echo "{$row['_model']}"; ?>" size="25"></td>
            </tr>
            // DONT KNOW HOW TO PRE-FILL
            <tr bgcolor="#E9E9E9">
            	<td style="padding-left: 5px;"><strong>Odometer:</strong></td>
                <td><select name="_odometer">
                <option value=""></option>
                <option value="Actual">Actual</option>
                <option value="Not Actual">Not Actual</option>
                <option value="TMU">TMU</option>
                </select>
                </td>
            </tr>
            <?php
            }
            ?>

 

Any help? How would I fill-in a drop down with MySQL record data?

           

 

 

[New Coder]

something like:

<?php
        $query  = "SELECT * FROM vehicles WHERE veh_id = '$id' LIMIT 1";

        $result = mysql_query($query) or die(mysql_error());
        while($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
        ?>
            // KNOW HOW TO PRE-FILL
            <tr bgcolor="#E9E9E9">
            	<td style="padding-left: 5px;"><strong>Model:</strong></td>
                <td><input type="text" name="_model" value="<?php echo "{$row['_model']}"; ?>" size="25"></td>
            </tr>
            // DONT KNOW HOW TO PRE-FILL
            <tr bgcolor="#E9E9E9">
            	<td style="padding-left: 5px;"><strong>Odometer:</strong></td>
                <td><?php 

echo '<select name="_odometer">';  
echo '<option>Choose Option</option>';

while($row = mssql_fetch_array($rs))
{  
  echo '<option value="'.$row[0].'">'.$row[0].'</option>';
   
}  

echo '</select>'; ?>
                </td>
            </tr>
            <?php
            }
            ?>

[EKINdesigns]

Grab the value of the drop down from the database the do something like:

 

<select name="_odometer">
<option value=""></option>
<option value="Actual"<?=($row['_odometer'] == "Actual") ? " selected" :NULL;?>>Actual</option>
<option value="Not Actual"<?=($row['_odometer'] == "NotActual") ? " selected" :NULL;?>>Not Actual</option>
<option value="TMU"<?=($row['_odometer'] == "TMU") ? " selected" :NULL;?>>TMU</option>
</select>

[EKINdesigns]

Also, why do you do:

<?php echo "{$row['_model']}"; ?>

Its better practice to do this instead:

<?php echo $row['_model']; ?>

[virtuexru]

Grab the value of the drop down from the database the do something like:

 

<select name="_odometer">
<option value=""></option>
<option value="Actual"<?=($row['_odometer'] == "Actual") ? " selected" :NULL;?>>Actual</option>
<option value="Not Actual"<?=($row['_odometer'] == "NotActual") ? " selected" :NULL;?>>Not Actual</option>
<option value="TMU"<?=($row['_odometer'] == "TMU") ? " selected" :NULL;?>>TMU</option>
</select>

 

Worked perfectly man, thanks a ton.