Code doesn't print what i wanted it too. Please help!
         
               Posted on 
16th Feb 2014 07:03 pm by  
admin
        
        Hi there,
I wrote this code to mae it so that in the form before it that the user said their username and then on this page it matches up the username with the username on the database and then uses the password of that users as $password. I am new to php and i thought that this would do the trick. But it doesn't. Instead of printing the password it prints "Resource id #6".
Here's the code: 
Code: 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Radio Ilam | Radio of the Suburbs</title><meta name="keywords" content="music note, free template, website template, CSS, XHTML" /><meta name="description" content="Music Note - free CSS template provided by templatemo.com" /><link href="templatemo_style.css" rel="stylesheet" type="text/css" /><style type="text/css">
.style1 {
   text-align: center;
}
.style2 {
   font-weight: bold;
   color: #C32929;
}
.style3 {color: #FF0000}
td {padding: 2px; vertical-align:top; border-top: 1px solid #CCC;}
</style></head>
<body>
<?php 
// Connects to your Database 
mysql_connect("removed", "removed", "removed") or die(mysql_error()); 
mysql_select_db("a1408362_data") or die(mysql_error()); 
//checks cookies to make sure they are logged in 
if(isset($_COOKIE['ID_my_site'])) 
{ 
}
$username = $_COOKIE['ID_my_site']; 
if ($username <> "administrator")
{ header("Location: members.php"); 
}
else {}
?>
<div id="templatemo_container_wrapper">
<div id="templatemo_container">
  <div id="templatemo_header">
      <div id="templatemo_site_title">Radio<span class="style2">Ilam</span></div>
      <div id="templatemo_site_slogan">Radio of the Suburbs</div>
   </div>    
   <div id="templatemo_menuleft"></div>    
   <div id="templatemo_menu">
        <ul>
         <li><a href="index.html">Home</a></li>
            <li><a href="competitions.php">Competitions</a></li>
<li><a href="#">Lates Music</a></li>
            <li><a href="#" class="current">Members</a></li>
            <li><a href="#">Listen Live</a></li>
            <li><a href="#">Contact Us</a></li>
        </ul>       
    </div>    
  <div id="templatemo_content">
      <div id="templatemo_left_column">
            <div class="templatemo_section2">
              <h1>Administrator</h1>
              <p>Welcome          
              <p><a href="logout.php">Logout</a></p>
            </div>
           <br />
           
      </div>        
      <div id="templatemo_right_column">
<?php
 $username = $_REQUEST['catergory'] ;
$password = mysql_query("SELECT password FROM users WHERE username = '$username'");
echo "$password"
?>
           <h1>User</h1>
           <p>                                  
            </p>
      </div>
   </div>
   <div id="templatemo_footer">Copyright © 2009 RadioIlam<a href="#"></a></div>
</div>
</div>
</body>
</html>       
      
       
		No comments posted yet	
	Your Answer:
	        Login to answer
        
147   15
 15  
 
    
    
 
Other forums
Uploading files/images via forms 
Hey all, I am building a database for work that will contain some minor data on plant species along 
Need help: how to catch acess of undefined class properties 
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code, 
first few characters only 
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see
Extract specific information from a PHP Multidimensional Array 
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear
onClick='location.href=index.htm'> not working 
Below is my code:
echo "<input type='button' value='redirect' onClick='location.h
double and single quotes in text fields acting up... help please 
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t
Switch letters in message (basic cryptology)... 
I am trying to switch letters around in a message for an application on my site (see here). The prob
INSERT for date range 
Hi all
I have the following table
Code: [Select]  `date` date
  `day` int(2)
  `
rename the file 
File.txt
Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E
How do I replace any number of character occurences with one occurrence? 
How do I replace any number of character occurences with one occurrence?
Let's say I have: