Re: Display results on html page
| From: | David Smith | Date: | Thu, 20 Mar 2003 22:58:25 +0000 |
| Subject: | Re: Display results on html page | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26531@lists.php.net to get a copy of this message | ||
You appear to have a ton of extra braces. I've modified your code below. That should do it, though keep in mind that your HTML is faulty too, though most browsers will probably tolerate it. :)
--Dave
Michelle Whelan wrote:
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>");