Display results on html page
| From: | Michelle Whelan | Date: | Thu, 20 Mar 2003 19:01:50 +0000 |
| Subject: | Display results on html page | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26527@lists.php.net to get a copy of this message | ||
I am looking to display results of a query inside of an html table. When I tested to see if this
was correct it returned with a blank page on my website.
Here is my code:
TIA
Michelle
/* If there was a problem with the query... */
if (!$result || @mysql_num_rows($result) < 1)
{
print("No entries in table $table.");
exit;
}
print("<h3><strong>RESULTS
FOR:'$ZipCode'</strong></h3>");
print('<table width="300" border="1">');
/* For each table entry returned... */
while($row = mysql_fetch_array($result))
{
print("<tr>");
print("<td width='25'> </td>");
}
{
print("<tr>");
print("<td width='75'><strong>Dirt
Type:</strong></td>");
print("<td>" . $row['havedirtype'] . "</td>");
print("<td colspan="3"> </td>");
}
{
print("<tr>");
print("<td width="75"><strong>Yards:</strong></td>");
print("<td>" . $row['noyards'] . "</td>");
print("<td colspan="3"> </td>");
}
{
print("<tr>");
print("<td width="75">Contact:</font></strong></td>");
print("<td>" . $row['contactname'] . "</td>");
print("<td colspan="3"> </td>");
}
{
print("<tr>");
print("<td width="75"><strong>Phone
#:</strong></td>");
print("<td>" . $row['areacode'] . "</td>");
print("<td> </td>");
print("<td>" . $row['prefix'] . "</td>");
print("<td> </td>");
print("<td>" . $row['suffix'] . "</td>");
print("<td> </td>");
}
{
print("<tr>");
print("<td width="25"> </td>");
print("<td width="75"><strong>Zip
Code:</strong></td>");
print("<td>" . $row['zipcode'] . "</td>");
print("<td colspan="3"> </td>");
}
{
print("<tr>");
print("<td width="25"> </td>");
print("<td width="75"><strong>Exp.
Date:</strong></td>");
print("<td>" . $row['date_month'] . "</td>");
print("<td> </td>");
print("<td>" . $row['date_day'] . "</td>");
print("<td> </td>");
print("<td>" . $row['date_year'] . "</td>");
print("<td> </td>");
}
{
print("<tr>");
print("<td colspan="5"> </td>");
}
{
print("<tr>");
print("<td width="25"> </td>");
print("<td width="75"><strong>Email:</strong></td>");
print("<td colspan="3"> </td>");
print("<td>" . $row['email'] . "</td>");
}
{
print("<tr>");
print("<td width="25"> </td>");
print("<td width="75"><strong>Job
City:</strong></td>");
print("<td colspan="3"> </td>");
print("<td>" . $row['jobcity'] . "</td>");
}
{
print("<tr>");
print("<td width="25"> </td>");
print("<td
width="75"><strong>X-Streets:</strong></td>");
print("<td colspan="3"> </td>")
print("<td>" . $row['xstreets'] . "</td>");
}
{
print("<tr>");
print("<td colspan="5"> </td>");
}
print("</table>");