Need help with display of results
| From: | Gloria L. McMillan | Date: | Fri, 06 Jun 2003 21:32:42 +0000 |
| Subject: | Need help with display of results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150550@lists.php.net to get a copy of this message | ||
Hi, again!
I did not see my question as yet so I will repost it.
I have had help writing HTML code to display the results of my PHP--> McSQL actions.
But when I attempt to show the DATE and q40 (comments) with the HTML code below,
all I see on screen is: ] in the upper left corner.
URL: http://DakotaCom.net/~glomc/forms/Adj03.html
(A poll on part-time faculty)
Here's the code for the display that is not working...
But the "]" may refer to earlier code in this long php file.
I did not send the whole file, only the HTML part.
/* Printing results in HTML */
/* COMMENTED 2002-05-02
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
*/
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("
<div class=\"colorfield\">
<table>
<tr><th>DATE</th><th>COMMENTS</th></tr>\n
<tr><td>%s</td><td>%s</td></tr>
</table>
</div>
<br />
<br />\n",
$row['added']);
$row['q40']);
}
/* Free resultset */
mysql_free_result($result);
/* Close the database connection */
mysql_close($link);
?>
</body>
</html>