对于每个= 1的结果,向表行添加单元格


for each result that = 1 add cell to table row?

<?
// Set the MySQL Configuration
$db_host       = "test";
$db_user       = "test";
$db_password   = "test";
$db_name       = "test";
$db_table      = "test";
// Start Connection
$db_connect        =  mysql_connect ($db_host, $db_user, $db_password);
// Select Database
$db_select        =  mysql_select_db ($db_name, $db_connect);

$query = "SELECT bird_owner, place_name, funds, place_description FROM bird_locations";
$query2 = "SELECT blue_bird, red_bird, green_bird, gold_bird, black_bird FROM bird_locations"; 
// this query ($query2) is to select just the birds so can check if any bird = 1 then add a new image cell in table
// Execution MySQL Query
$result = mysql_query($query);

if($result)
{
// table headers
echo '<table width="90%" border="0" align="center" cellspacing="2" cellpadding="10">

<p><p><p>
<tr>
<th align="center"><b>Owner</b></th>
<th align="center"><b>PlaceName</b></th>
<th align="center"><b>Birds</b></th>
<th align="center"><b>Funds</b></th>
<th align="center"><b>Description</b></th>
</tr>
';
//now i add a new row for each result which works.
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 {
     echo '<tr>
    <td align="center"><b>' . $row['bird_owner'].'</b></td>
    <td align="center"><b>' . $row['place_name'].'</b></td>
    <td align="center"><b><img src="bird_blue_50px.png"/></b></td> 
    <td align="center"><b>' . $row['funds'].'L$</b></td>
    <td align="center"><b>' . $row['place_description'].'</b></div></td>
    </tr>';
 }
echo '</table>';
}

//Close MySQL connection
mysql_close($db_connect);
?>

当生成行时,一行的第三个单元格是一只鸟的图像,但是我如何才能使它这样,如果数据库中一只鸟的值为1,它会显示另一只鸟图像的额外单元格?

。如果

  • blue_bird值等于1显示行
  • 中的图像
  • red_bird value = 1
  • 显示红鸟图像
  • green_bird值等于1显示绿鸟图像
  • gold_bird value = show gold bird image
  • black_bird value = show black bird image

如果there value = 0那么就不要在table

中显示该图像

分割echo:

echo '<tr>
<td align="center"><b>' . $row['bird_owner'].'</b></td>
<td align="center"><b>' . $row['place_name'].'</b></td>';
if ($row['blue_bird']==1){
   echo '<td>Etc...';
}
echo '<td align="center"><b><img src="bird_blue_50px.png"/></b></td> 
<td align="center"><b>' . $row['funds'].'L$</b></td>
<td align="center"><b>' . $row['place_description'].'</b></div></td>
</tr>';

同时,mysql_query将不再支持很长时间:http://php.net/manual/en/function.mysql-query.php