Dude, forget colors and stuff for the moment, you just want to get the page to display properly. You have many problems where your print statements are concerned without going into the coat of many colors.
-----Original Message----- From: Karl James [mailto:karl.james@;verizon.net] Sent: Tuesday, November 05, 2002 4:43 AM To: 'Jay Blanchard' Subject: RE: [PHP] why does this happen? I changed all font codes to #333333 And nothing happend -----Original Message----- From: Jay Blanchard [mailto:jay.blanchard@;niicommunications.com] Sent: Tuesday, November 05, 2002 11:39 AM To: 'Karl James'; 'PHP General' Subject: RE: [PHP] why does this happen? And all you changed was the <body text="#FFFFFF"> tag? If so, the code you sent was before you chnaged it to <body text="#000000"> (those are zeros) -----Original Message----- From: Karl James [mailto:karl.james@;verizon.net] Sent: Tuesday, November 05, 2002 4:35 AM To: 'Jay Blanchard' Subject: RE: [PHP] why does this happen? Here is the code jay! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>2002 Players</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body text="#FFFFFF"> <? $db = mysql_connect( "198.63.221.3" ,"ultimatefootball", "kjames1973" ); IF( !$db ) { echo "Unable to connect to the MySQL Database"; } mysql_select_db("ultimatefootballleague"); $query = "SELECT * FROM players"; $result = MYSQL_QUERY($query); $total_rows = mysql_num_rows($result); if (!$total_rows) { print "<HTML><BODY><h1>Table $name is empty</h1></BODY></HTML>"; return; } $row = mysql_fetch_row($result); $total_cols = count($row); print "<HTML><BODY>"; print "<table width='100%' border='1' cellspacing='0' cellpadding='0' align='center' td bgcolor="#0099CC"><font color="#FFFFFF">>"; print "<tr><td colspan=$total_cols align=center>$name Table (rows: $total_rows, column: $total_cols)</td></tr>"; print "<tr>"; $i=0; while($i < $total_cols){ print "<td>"; print $row[$i]; print "</td>"; $i++; } print "</tr>"; while($row = mysql_fetch_row ($result)) { $i = 0; print "<tr>"; while($i < $total_cols){ print "<td>"; print $row[$i]; print "</td>"; $i++; } print "</tr>"; } mysql_free_result($result); print "</TABLE></BODY></HTML>"; function ShowTable($name){ MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect"); @MYSQL_SELECT_DB("$dbName") OR DIE("Unable to select database"); $query = "select * from $name"; $result = MYSQL_QUERY($query); $total_rows = mysql_num_rows($result); if (!$total_rows) { print "<HTML><BODY><h1>Table $name is empty</h1></BODY></HTML>"; return; } $row = mysql_fetch_row($result); $total_cols = count($row); print "<HTML><BODY>"; print "<table width='100%' border='1' cellspacing='0' cellpadding='0' align='center'>"; print "<tr><td colspan=$total_cols align=center>$name Table (rows: $total_rows, column: $total_cols)</td></tr>"; print "<tr>"; $i=0; while($i < $total_cols){ print "<td>"; print $row[$i]; print "</td>"; $i++; } print "</tr>"; while($row = mysql_fetch_row ($result)) { $i = 0; print "<tr>"; while($i < $total_cols){ print "<td>"; print $row[$i]; print "</td>"; $i++; } print "<td><input type=checkbox name=\"opt[{$row[0]}]\"></td>"; print "</tr>"; } print "</TABLE></BODY></HTML>"; } ?> </body> </html> -----Original Message----- From: Jay Blanchard [mailto:jay.blanchard@;niicommunications.com] Sent: Tuesday, November 05, 2002 11:32 AM To: 'Karl James'; 'PHP General' Subject: RE: [PHP] why does this happen? [snip] I did the changes but. Now nonthing appears at all on the web page Please refresh to see what im saying.. [/snip] Now, if that was all you changed you should not have a problem, but you must have changed more than that because now there is nothing in the page. Can you show us your code? [hint to get more help] When responding to a post where someone attempts to help you make sure to respond to the mailing list in the event the original helpful citizen went to a meeting or the bathroom or something. [/hint] JB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
