strange mysql results not appearing

rofl90 · February 20, 2008

heres my file, info is defo in there checked via phpmyadmin:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Professional Website, Flash & Graphic Designers + Site Marketing</title>

    <link href="http://www.codeetech.com/css/global.php" rel="stylesheet" type="text/css">
<link rel="icon" href="/favicon.ico">
</head>
<body>

<img src="http://www.codeetech.com/images/top_hline.gif" width="100%" height="31" alt="top border">

<table id="main" cellpadding="0" align="center">

  	<tr><td colspan=4>
	<table cellpadding="0">

		<tr>
			<td nowrap>				<td nowrap>
							<?php

			include("../go/networklinks/index.php");

			?>
			</td>
			<td id="topRightLinks">
			<?php

			include("../go/topleftlinks/index.php");

			?>

			</td>

			<td style="vertical-align: middle;" nowrap>
<?php 

include("../go/icons/index.php");

?>
 				</td>
		</tr>
	</table>
  	</td></tr>

  	<tr>
	<td class="sideBorder" rowspan=2><img src="http://www.codeetech.com/images/white_spacer.gif" width="1" height="135" alt="spacer"></td>
	<td><img src="http://www.codeetech.com/images/white_spacer.gif" width="199" height="1" alt="spacer"></td>
	<td rowspan=2 width="100%">
	<table width="540" cellpadding="0">
		 <tr>
		   <td colspan="3"><script type="text/javascript" language="JavaScript1.1">var MM_fileIndex = 0;</script><script type="text/javascript" language="JavaScript1.1" src="includes/root_header_flash.js"></script>
		     <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="539" height="180">
                   <param name="movie" value="../images/flash.swf">
                   <param name="quality" value="high">
                   <embed src="../images/flash.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="539" height="180"></embed>
                 </object></td>
		 </tr>
		<tr>
			<td width="6%"><img src="http://www.codeetech.com/images/white_spacer.gif" width="8" height="1" alt="spacer"></td>
			<td width="85%" valign="top">
			<div id="mainBody">

<!-- body -->
	<table cellpadding="0" class="body">
		<tr>
			<td>

				<br>



				<h2 align="center">Login</h2>

				<p>
<?php
$username = "xx";
$password = "xx";
$randomword = "xx";

if (isset($_COOKIE['MyLoginPage'])) {
   if ($_COOKIE['MyLoginPage'] == md5($password.$randomword)) {
?>
<?php
$host = 'x';
$user = 'x';
$pass = 'x';
$db = 'x';
mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($db);

$info = mysql_query("SELECT * FROM support;");
$i = mysql_fetch_object($info);

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Email</th> <th>Reason</th> <th>Message</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $info )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['name'];
echo "</td><td>"; 
echo $row['email'];
echo "</td><td>"; 
echo $row['reason'];
echo "</td><td>"; 
echo $row['message'];
echo "</td></tr>"; 
} 

echo "</table>";
mysql_close()
?>
</p>				  
			</tr>
	</table>

	<h2 align="center"> </h2>

        <div style="padding: 0px 10px 0 10px; background-color: #fff; "></div>

	<a href="tools_web_developer_comparison_checklist.php" title="web developer comparison checklist"></a>

				<?php

include("../go/promos/index.php");


?><br>
				<br>
		  </div>					</td>

				<td width="9%"><img src="http://www.codeetech.com/images/white_spacer.gif" width="12" height="1" alt="spacer"></td>
	  </tr>
		</table>		</td>

	<td class="sideBorder" rowspan="2"><img src="http://www.codeetech.com/images/white_spacer.gif" width="1" height="7" alt="spacer"></td>
  	</tr>
<tr>
	<td id="logoBox"><img src="http://www.codeetech.com/images/spacer.gif" width="199" height="20" alt="spacer"><br>
		<a href="http://www.codeetech.com"><img src="http://www.codeetech.com/go/images/headerimg.gif" alt="CodeeTech Web Design, Website Development, Flash"></a><br>
		<img src="http://www.codeetech.com/images/spacer.gif" width="15" height="40" alt="spacer"><br>
		<img src="http://www.codeetech.com/images/L-curve_top.gif" width="201" height="7" alt="spacer"><br>
		<table cellpadding="0">
			<tr><td><img src="http://www.codeetech.com/images/white_spacer.gif" width="8" height="1" alt="spacer"></td><td>
			<div id="leftMenu">
<!-- left menu-->

<?php

include ("../go/menu/index.php");

?>



<h3>Featured Client:</h3>
<br>
	<table class="featureBox" cellpadding="0">
<tr><td><img src="/images/featured_site_top.gif" alt="spacer"></td></tr>
<tr>
	<td align="center" style="padding: 0px 4px 0px 4px;"><?php

	include("../go/latestclient/index.php")

	?>
<br>
        <span class="featureBoxBodyCaption"></span>
<?php 
echo file_get_contents("../go/footercaption/index.php");
?>
</tr>
<tr><td><img src="/images/featured_site_bottom.gif" alt="spacer"></td></tr>

</table>
	<h3>Client Quote</h3>
Quote filler <br>
<br>
<div style="text-align: right; background-color: #FFFFFF;">Della Melton <br> 
  Voice Over Artist
</div><br>
<br> 
		   <br>
		   </div>
		</td></tr>
</table>	</td></tr>
<tr><td colspan=4>
  <?php
  
  include("../go/footer/index.php");
  
  
  ?>
</td></tr>
</table>
</body>
</html>


<?php
      exit;
   } else {
      echo "<p>Bad cookie. Clear please clear them out and try to login again.</p>";
      exit;
   }
}

if (isset($_GET['p']) && $_GET['p'] == "login") {
   if ($_POST['name'] != $username) {
      echo "<p>Sorry, that username does not match. Use your browser back button to go back and try again.</p>";
      exit;
   } else if ($_POST['pass'] != $password) {
      echo "<p>Sorry, that password does not match. Use your browser back button to go back and try again.</p>";
      exit;
   } else if ($_POST['name'] == $username && $_POST['pass'] == $password) {
      setcookie('MyLoginPage', md5($_POST['pass'].$randomword));
      header("Location: $_SERVER[php_SELF]");
   } else {
      echo "<p>Sorry, you could not be logged in at this time. Refresh the page and try again.</p>";
   }
}
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>?p=login" method="post"><fieldset>
<label><input type="text" name="name" id="name" /> Name</label><br />
<label><input type="password" name="pass" id="pass" /> Password</label><br />
<input type="submit" id="submit" value="Login" />
</fieldset></form>


</p>				  
			</tr>
	</table>

	<h2 align="center"> </h2>

        <div style="padding: 0px 10px 0 10px; background-color: #fff; "></div>

	<a href="tools_web_developer_comparison_checklist.php" title="web developer comparison checklist"></a>

				<?php

include("../go/promos/index.php");


?><br>
				<br>
		  </div>					</td>

				<td width="9%"><img src="http://www.codeetech.com/images/white_spacer.gif" width="12" height="1" alt="spacer"></td>
	  </tr>
		</table>		</td>

	<td class="sideBorder" rowspan="2"><img src="http://www.codeetech.com/images/white_spacer.gif" width="1" height="7" alt="spacer"></td>
  	</tr>
<tr>
	<td id="logoBox"><img src="http://www.codeetech.com/images/spacer.gif" width="199" height="20" alt="spacer"><br>
		<a href="http://www.codeetech.com"><img src="http://www.codeetech.com/go/images/headerimg.gif" alt="CodeeTech Web Design, Website Development, Flash"></a><br>
		<img src="http://www.codeetech.com/images/spacer.gif" width="15" height="40" alt="spacer"><br>
		<img src="http://www.codeetech.com/images/L-curve_top.gif" width="201" height="7" alt="spacer"><br>
		<table cellpadding="0">
			<tr><td><img src="http://www.codeetech.com/images/white_spacer.gif" width="8" height="1" alt="spacer"></td><td>
			<div id="leftMenu">
<!-- left menu-->

<?php

include ("../go/menu/index.php");

?>



<h3>Featured Client:</h3>
<br>
	<table class="featureBox" cellpadding="0">
<tr><td><img src="/images/featured_site_top.gif" alt="spacer"></td></tr>
<tr>
	<td align="center" style="padding: 0px 4px 0px 4px;"><?php

	include("../go/latestclient/index.php")

	?>
<br>
        <span class="featureBoxBodyCaption"></span>
<?php 
echo file_get_contents("../go/footercaption/index.php");
?>
</tr>
<tr><td><img src="/images/featured_site_bottom.gif" alt="spacer"></td></tr>

</table>
	<h3>Client Quote</h3>
Quote filler <br>
<br>
<div style="text-align: right; background-color: #FFFFFF;">Della Melton <br> 
  Voice Over Artist
</div><br>
<br> 
		   <br>
		   </div>
		</td></tr>
</table>	</td></tr>
<tr><td colspan=4>
  <?php
  
  include("../go/footer/index.php");
  
  
  ?>
</td></tr>
</table>
</body>
</html>

Sign In

strange mysql results not appearing

Recommended Posts

rofl90

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information