<?
// 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