Whats wrong with this code?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

Well, that code is valid, if it isn't working for you the problem doesn't lie there, it is above that code snippet.
qartis
Forum Contributor
Posts: 271
Joined: Sat Dec 14, 2002 4:43 pm
Location: BC, Canada
Contact:

Post by qartis »

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"); 
} 
?>
User avatar
nick2
Forum Contributor
Posts: 118
Joined: Fri Jul 25, 2003 2:34 pm

Post by nick2 »

Parse error: parse error, expecting `','' or `';'' in /home/virtual/site9/fst/var/www/html/tradingsystem/members.php on line 35

error :(
qartis
Forum Contributor
Posts: 271
Joined: Sat Dec 14, 2002 4:43 pm
Location: BC, Canada
Contact:

Post by qartis »

Oops...

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"); 
} 
?>
Post Reply