Edit only the # sign and the 6 characters following it. There is a good color reference at http://www.visibone.com/colorlab/
-----Original Message----- From: Karl James [mailto:karl.james@;verizon.net] Sent: Tuesday, November 05, 2002 4:48 AM To: 'Jay Blanchard' Subject: RE: [PHP] why does this happen? Jay I got it fixed... How do I edit the font and the colors of tables and backgrounds Go ahead and it refresh!! -----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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
