Jump to content

strange mysql results not appearing

rofl90

By rofl90
in PHP Coding Help

 Share

Recommended Posts

rofl90 Advanced Member

rofl90

Posted
Posted

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>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.