Posted: Sun Aug 17, 2003 11:58 pm
Well, that code is valid, if it isn't working for you the problem doesn't lie there, it is above that code snippet.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?
if (isset($_COOKIEї"logged_in"])){
$db_name = "slices_net";
$table_name = "trading";
$connection = mysql_connect("localhost", "slices", "password") or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$result = mysql_query("SELECT * FROM `trading` WHERE 1") or die(mysql_error());
if (mysql_num_rows($result)>0){
?>
<html>
<head>
<title>Members View</title>
</head>
<body>
<div align="center">
<center>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="51%" id="AutoNumber1">
<tr>
<td width="33%" bgcolor="#999999"><font size="2" face="Verdana">User(s):</font></td>
<td width="33%" bgcolor="#999999"><font size="2" face="Verdana">Location:</font></td>
<td width="34%" bgcolor="#999999"><font size="2" face="Verdana">Signature:</font></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="51%" id="AutoNumber2">
<?
while ($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td width="33%">{$rowї'ID']}</td>";
echo "<td width="33%">{$rowї'location']}</td>";
echo "<td width="34%">{$rowї'signature']}</td>";
echo "</tr>";
}
?>
</table>
</center>
</div>
</body>
</html>
<?
} else {
echo "No rows returned";
}
mysql_free_result($result);
} else {
header( "Location: http://slices.net/tradingsystem/nologin.html");
}
?>Code: Select all
<?
if (isset($_COOKIE["logged_in"])){
$db_name = "slices_net";
$table_name = "trading";
$connection = mysql_connect("localhost", "slices", "password") or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$result = mysql_query("SELECT * FROM `trading` WHERE 1") or die(mysql_error());
if (mysql_num_rows($result)>0){
?>
<html>
<head>
<title>Members View</title>
</head>
<body>
<div align="center">
<center>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="51%" id="AutoNumber1">
<tr>
<td width="33%" bgcolor="#999999"><font size="2" face="Verdana">User(s):</font></td>
<td width="33%" bgcolor="#999999"><font size="2" face="Verdana">Location:</font></td>
<td width="34%" bgcolor="#999999"><font size="2" face="Verdana">Signature:</font></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="51%" id="AutoNumber2">
<?
while ($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td width="33%">{$row['ID']}</td>";
echo "<td width="33%">{$row['location']}</td>";
echo "<td width="34%">{$row['signature']}</td>";
echo "</tr>";
}
?>
</table>
</center>
</div>
</body>
</html>
<?
} else {
echo "No rows returned";
}
mysql_free_result($result);
} else {
header( "Location: http://slices.net/tradingsystem/nologin.html");
}
?>