dongxi5423 2014-07-04 03:46
浏览 24
已采纳

使用'if'和mysqli [关闭]

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.

  • 写回答

1条回答 默认 最新

  • ds08541 2014-07-04 03:48
    关注

    You're just missing a = sign to the if statement bro. :)

    it's == right?

    if ($rowo_1['board'] == "Y") 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形