Question

Im a newbie ih php。试图通过,但数据没有显示。也没有错误。需要一些专家的建议。

法典

      <?php

include( connectdb.php );     
$sql="SELECT id,name FROM companydetailstbl";
$result=mysql_query($sql);    
$options="";    
while ($row=mysql_fetch_array($result)) {    
    $id=$row["id"];
    //echo $id;
    $thing=$row["name"];
    $options.="<OPTION VALUE="$id">".$thing;
}
?>
        <table width="900" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="22%">Company Name </td>
            <td width="3%">:</td>
            <td width="75%"><SELECT NAME="thing">
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT></td>
          </tr>
          <tr>
            <td>Installation Date </td>
            <td>:</td>
            <td><input type="text" name="ins_dt" />
            (ddmmyyyy)</td>
          </tr>
          <tr>
            <td>Expiry Date </td>
            <td>:</td>
            <td><input type="text" name="ex_dt" />
            (ddmmyyyy)</td>
          </tr>
          <tr>
            <td>Status</td>
            <td>:</td>
            <td> </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td><input type="submit" name="Submit" value="Update" />
            <input type="submit" name="Submit2" value="Reset" /></td>
          </tr>
        </table>

请提供帮助。成就

Answer 1

我不知道您目前正在使用哪些DTD,但根据 , 4.0 具体说明 ,你需要关闭<>option>。



$options .=  <option value="  . $id .  ">  . $thing .  </option> ;


还有,

<select name="thing">
    <option value="0">Choose</option>
    <?php echo $options; ?>
</select>

Answer 2

请试图关闭两边

 $options.="<OPTION VALUE="$id">".$thing."</OPTION>";

also edit

<SELECT NAME="thing">
<OPTION VALUE=0>Choose</OPTION>
<?=$options?>
</SELECT>

Answer 3

<?php

include( connectdb.php );     
$sql="SELECT id,name FROM companydetailstbl";
$result=mysql_query($sql);

?>

<table width="900" border="0" cellspacing="0" cellpadding="0">
    <tr>
        <td width="22%">Company Name </td>
        <td width="3%">:</td>
        <td width="75%">
            <select name="thing">
            <?php
                while($row = mysql_fetch_object($result)){
            ?>
                    <option value="<?=$row["id"]; ?>"><?=$row["name"]; ?></option>
            <?php
                }
                ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Installation Date </td>
        <td>:</td>
        <td><input type="text" name="ins_dt" />(ddmmyyyy)</td>
    </tr>
    <tr>
        <td>Expiry Date </td>
        <td>:</td>
        <td><input type="text" name="ex_dt" />(ddmmyyyy)</td>
    </tr>
    <tr>
        <td>Status</td>
        <td>:</td>
        <td> </td>
    </tr>
    <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>
            <input type="submit" name="Submit" value="Update" />
            <input type="submit" name="Submit2" value="Reset" />
        </td>
    </tr>
</table>

Hope it helps

友情链接