Re: [PHP] Table format needs php correction

2003-08-31 Thread Curt Zirzow
* Thus wrote Gloria L. McMillan ([EMAIL PROTECTED]):
 This is all so advanced.  Is it ready to be in place of the table HTML  that I 
 already have?
 

Yes it should be. I hope it isn't so advanced that you can't
understand what exactly I'm doing.  That would rather defeat the
purpose of me writing that up.

 I copied it to word and saved it as a .txt file.  IN IE it looked better than in my
 Netscape.

My appologies for that, I havn't tested the site in mozilla/netscape
yet, only IE and opera. I'm actually downloading mozilla right now.
 

HTH,

Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

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



Re: [PHP] Table format needs php correction

2003-08-30 Thread Curt Zirzow
* Thus wrote Gloria L. McMillan ([EMAIL PROTECTED]):
 Hi!

Hello Gloria,

 
 This is a problem of the table formatting on a form in MySQL and PHP.
 It may be in the HTML table code.
 ...
 Here is the URL to view PHP HTML table as it appears on screen:
 http://DakotaCom.net/~glomc/forms/CAT.php

I think you need to take a step back for a moment. First consider
how you want the data to be presented in html, then the php code
will be very simple.

From what I see and how I would prefer to set the layout would be
something like this:

 Date  Name   Course  Unit
 Aug 30 2003   Gloria WRT 102 Fall 03 Essay 1

 Q1 data for q1
 Q2 data for q2
 ...


Then easily put that into a html table structure:

tr
 tdDate/tdtdName/tdtdCourse/tdtdUnit/td
/tr
tr
 tdAug 30 2003/tdtdGloria /tdtdWRT 102 Fall 03/tdtdEssay 1/td
/tr
tr
 tdQ1/tdtd colspan=3data for q1/td
/tr
tr
 tdQ2/tdtd colspan=3data for q2/td
tr
 ...

Now inside your fetch_array loop just use that template above using
php variables instead of text and table column attributes in the
appropriate places will result in a decent looking site.


Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

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



Re: [PHP] Table format needs php correction

2003-08-30 Thread andu
On Sat, 30 Aug 2003 10:23:49 -0700
Gloria L. McMillan [EMAIL PROTECTED] 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

The SQL has nothing to do with it (though make sure the query returns
what you expect), it's just how you format the table with the data you
have. My advice is to start it simple with no colors or stuff like that
and work on it until you get the proper table (html). Forget about using
other people's code in something like this and try to understand the
logic before you get to beautifying your output. I just spent the last
couple of days with tables formating, css, etc
 
 
 
 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 '-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 \ttr\n;
  foreach ($line as $col_value) {
   print \t\ttd$col_value/td\n;
  }
  print \t/tr\n;
 }
 print /table\n;
 */
 while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  printf(
 div class=\colorfield\
 table
  trthDate/ththName/ththCourse/ththUnit/th\n
 
 trtd%s/tdtd%s/tdtd%s/tdtd%s/td/tr\n
 
  trth = colspan = 4 Q1 /th\n
  trtd%s/td\n
 
  trth = colspan = 4 Q2 /th\n
  trtd%s/td\n
 
  trth = colspan = 4 Q3 /th\n
  trtd%s/td\n
 
  trth = colspan = 4 Q4 /th\n
  trtd%s/td\n
 
  trthQ5/ththQ6/ththQ7/th\n
 
  trtd%s/tdtd%s/tdtd%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
 
 
 


-- 
Regards, Andu Novac

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



Re: [PHP] Table format needs php correction

2003-08-30 Thread Curt Zirzow
* Thus wrote Curt Zirzow ([EMAIL PROTECTED]):
 * Thus wrote Gloria L. McMillan ([EMAIL PROTECTED]):
  Hi!
 
 Hello Gloria,
 
  
  This is a problem of the table formatting on a form in MySQL and PHP.
  It may be in the HTML table code.
  ...
  Here is the URL to view PHP HTML table as it appears on screen:
  http://DakotaCom.net/~glomc/forms/CAT.php
 
 I think you need to take a step back for a moment. First consider
 how you want the data to be presented in html, then the php code
 will be very simple.

Ok, I had a little extra time this morning :)

  http://zirzow.dyndns.org/html/php/html/table.php


Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

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



Re: [PHP] Table format needs php correction

2003-08-30 Thread Gloria L. McMillan
Thanks but the lines are all running together in that URL.
I don't know why.
They are not breaking at the end of each line.

Could you re-save a different way?
Maybe send to me as a text file?

Thanks,

Gloria


Curt Zirzow wrote:

 * Thus wrote Curt Zirzow ([EMAIL PROTECTED]):
  * Thus wrote Gloria L. McMillan ([EMAIL PROTECTED]):
   Hi!
 
  Hello Gloria,
 
  
   This is a problem of the table formatting on a form in MySQL and PHP.
   It may be in the HTML table code.
   ...
   Here is the URL to view PHP HTML table as it appears on screen:
   http://DakotaCom.net/~glomc/forms/CAT.php
 
  I think you need to take a step back for a moment. First consider
  how you want the data to be presented in html, then the php code
  will be very simple.

 Ok, I had a little extra time this morning :)

   http://zirzow.dyndns.org/html/php/html/table.php

 Curt
 --
 I used to think I was indecisive, but now I'm not so sure.

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



Re: [PHP] Table format needs php correction

2003-08-30 Thread Gloria L. McMillan
This is all so advanced.  Is it ready to be in place of the table HTML  that I already 
have?

I copied it to word and saved it as a .txt file.  IN IE it looked better than in my
Netscape.

Gloria


Curt Zirzow wrote:

 * Thus wrote Curt Zirzow ([EMAIL PROTECTED]):
  * Thus wrote Gloria L. McMillan ([EMAIL PROTECTED]):
   Hi!
 
  Hello Gloria,
 
  
   This is a problem of the table formatting on a form in MySQL and PHP.
   It may be in the HTML table code.
   ...
   Here is the URL to view PHP HTML table as it appears on screen:
   http://DakotaCom.net/~glomc/forms/CAT.php
 
  I think you need to take a step back for a moment. First consider
  how you want the data to be presented in html, then the php code
  will be very simple.

 Ok, I had a little extra time this morning :)

   http://zirzow.dyndns.org/html/php/html/table.php

 Curt
 --
 I used to think I was indecisive, but now I'm not so sure.

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