RE: [PHP] why does this happen?
| From: | Jay Blanchard | Date: | Tue, 05 Nov 2002 19:53:54 +0000 |
| Subject: | RE: [PHP] why does this happen? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-122854@lists.php.net to get a copy of this message | ||
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