[Resolved] displaying records in a html table

timmybuck

HI Guys,

Im tryiong to display fields from my database in a table with altenate coloured rows. can anyone help fix what i have so far

<html>
<head> </head>
<body>
<?php

$color[0] = "red";

$color[1] = "yellow";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");
mysql_select_db('helpdesk');
$sql = "SELECT jobId, , room, computers,description, date FROM requests_table ;

$result = mysql_query($sql);

echo "<table>\n";

echo " <tr>\n";

echo " <th>JobID</th>\n";

echo " <th>Room</th>\n";

echo " <th>Computers</th>\n";

echo " <th>description</th>\n";

echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">\n";

{

echo '<td><a href="tech.php?jobId='.$row['jobId'].'">' . $row['jobId'] . "</a></td>"; }
else {
echo '<td>'.$row['room'].'</td>';}

echo ' <td>'.$row['computers'].'</td>'."\n";  
echo ' <td>'.$row['description'].'</td>'."\n";

</body>
</html>

Weedpacket

What's broken? Apart from the missing '}', and missing if() statement?

timmybuck

Hi Guys

have managed to fix my problem, to some degree. The only problem now is that the lines of colour are displaying above the record fieldsm when the records should be displayed in lines of colour

here is my code

<html>
<head> </head>
<body>
<?php

$color[0] = "red";

$color[1] = "yellow";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");
mysql_select_db('helpdesk');
$sql = "SELECT jobId, room, computers, description, date FROM requests_table" ;

$result = mysql_query($sql);

echo "<table>\n";

echo " <tr>\n";

echo " <th>JobID</th>\n";

echo " <th>Room</th>\n";

echo " <th>Computers</th>\n";

echo " <th>description</th>\n";

echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">'</tr>'\n";

{

echo '<td><a href="tech.php?jobId='.$row['jobId'].'">' . $row['jobId'] . "</a></td>"; }
echo '<td>'.$row['room'].'</td>';
echo ' <td>'.$row['computers'].'</td>'."\n";

echo ' <td>'.$row['description'].'</td>'."\n";
echo ' </tr>'."\n";

//echo '</table>';
}
?>

</body>
</html>