EDIT: I forgot to use ==. This topic can be closed. I want a different area in the dropdown to be selected depending on a row in a database table. I thought this code would do the trick, but it always selects 'yes'. Here is my PHP:
<?php
$con=mysqli_connect("localhost","*******","*********","FRTM");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$member_number = mysqli_real_escape_string($con, $_POST['last_name']);
echo "<form action='query2.php' method='post'>";
$resultoverall1 = mysqli_query($con,"SELECT * FROM history_overall WHERE member_number='$member_number'");
while($rowo_1 = mysqli_fetch_array($resultoverall1)) {
if ($rowo_1['board']="Y") {
echo "<p>Board: <select name='board'>";
echo "<option value=''>Please Select</option>";
echo "<option value='Y' selected>Yes</option>";
echo "<option value='N'>No</option>";
echo "<option value='NM'>Need Mailing</option>";
echo "</select></p>";
}
elseif ($rowo_1['board']="NM") {
echo "<p>Board: <select name='board'>";
echo "<option value=''>Please Select</option>";
echo "<option value='Y'>Yes</option>";
echo "<option value='N'>No</option>";
echo "<option value='NM' selected>Need Mailing</option>";
echo "</select></p>";
}
elseif ($rowo_1['board']="N") {
echo "<p>Board: <select name='board'>";
echo "<option value=''>Please Select</option>";
echo "<option value='Y'>Yes</option>";
echo "<option value='N' selected>No</option>";
echo "<option value='NM'>Need Mailing</option>";
echo "</select></p>";
}
}
mysqli_close($con);
?>
Any help is appreciated.