Modification

[Xtremer360]

This code works when theres no predefined value however I'm trying to modify it in case there IS a value from the DB which is from the  " . $row2['content'] . " data.

 

 echo "<select name=" . $row2['ID'] . " id=" . $row2['ID'] . " class=dropdown biofield title=" . $row2['fullName'] . " >";
                    echo "<option value= >None</option>";
                    if ($styleID == 1 || $styleID == 2 || $styleID == 6) {
                        $charactersQuery = "
                        SELECT 
                            characters.ID, 
                            characters.characterName 
                        FROM 
                            characters 
                        WHERE 
                            characters.styleID = 3
                        ORDER BY 
                            characters.characterName";
                    }
                    else {
                        $charactersQuery = "
                        SELECT 
                            characters.ID, 
                            characters.characterName 
                        FROM 
                            characters 
                        WHERE 
                            characters.styleID IN (1,2,6)
                        ORDER BY 
                            characters.characterName";
                    }
                    
                    $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                    
                    while ( $row3 = mysqli_fetch_array ($charactersResult, MYSQLI_ASSOC)) { 
                        echo "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                    }
                    
                    echo "</select>";

 

I normally use something like this but with the other code not sure how to modify it to work the same way.

 

while ( $champion_row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=\"".$champion_row['ID']."\" ";
        					if($champion_row['ID'] == $row['champID']) {
        						     print " SELECTED";
        					}
                            print ">".$champion_row['characterName']."</option>\r";
                    }

[Xtremer360]

Any suggestions?

[spiderwell]

i cant even see " . $row2['content'] . "  in your code,

what exactly are you trying to do, preselect an option if it is matching in  $row2['content'] ?

[Xtremer360]

Yes

[spiderwell]

i cant even see " . $row2['content'] . "  in your code,

 

its very hard to second guess your code if we can't see it.

 

I am guessing its within the $row3 loop that you want 'selected' echoed into the <option>, but you haven't given us anything to work with 

[Xtremer360]

That's all the involved code.

[Xtremer360]

Fixed.

[spiderwell]

it can't be because you ask this

This code works when theres no predefined value however I'm trying to modify it in case there IS a value from the DB which is from the  " . $row2['content'] . " data.

 

but it doesn't appear in any of the code you have posted!?!

 

 

EDIT:: glad you fixed it , as I had no clue