[PHP] Re: Table format needs php correction

[Al]

There are too many problems with your code for anyone to spend the time 
going thru them all.

I'd suggest, first constructing a regular html table that looks like you 
want it to.  Hint, IE6 requires something in TDs [e.g.,  ] for 
borders to show. 

When the table looks the way you want it to, validate the code at 
http://validator.w3.org/

Then work on your php code to generate the exact same html.

Gloria L. McMillan wrote:

Hi!

This is a problem of the table formatting on a form in MySQL and PHP.
It may be in the HTML table code.
The problem is one that must be frequent.  I have a mixture of one character
and long fill-in text items.
My table now looks awkward. Somebody gave me a complex table that puts colors as 
backgrounds
behind the headers.  Could that be the problem?  -Gloria
Here is the URL to view PHP HTML table as it appears on screen:
http://DakotaCom.net/~glomc/forms/CAT.php
Here is the mysql create table structure file:

#
# Table structure for table 'CAT'
#
CREATE TABLE CAT (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  added datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  name varchar(50) NOT NULL,
  course varchar(50) NOT NULL,
  unit varchar(50) NOT NULL,
  q1 text NOT NULL,
  q2 text NOT NULL,
  q3 text NOT NULL,
  q4 text NOT NULL,
  q5 varchar(10) NOT NULL,
  q6 varchar(10) NOT NULL,
  q7 varchar(10) NOT NULL,
  PRIMARY KEY (id)
);
Here is the table HTML part of the PHP file:

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>Name</th><th>Course</th><th>Unit</th>\n
<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n

<tr><th = colspan = 4> Q1 </th>\n
<tr><td>%s</td>\n
<tr><th = colspan = 4> Q2 </th>\n
<tr><td>%s</td>\n
<tr><th = colspan = 4> Q3 </th>\n
<tr><td>%s</td>\n
<tr><th = colspan = 4> Q4 </th>\n
<tr><td>%s</td>\n
<tr><th>Q5</th><th>Q6</th><th>Q7</th>\n

<tr><td>%s</td><td>%s</td><td>%s</td>\n
</table>
</div>\n",
  $row['added'],
  $row['name'],
  $row['course'],
  $row['unit'],
  $row['q1'],
  $row['q2'],
  $row['q3'],
  $row['q4'],
  $row['q5'],
  $row['q6'],
  $row['q7']);
}

/* Free resultset */
mysql_free_result($result);
/* Close the database connection */
mysql_close($link);
?>
</body>
</html>
 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php