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 
Other forums
The type or namespace name 'ServiceModel' does not exist in the namespace 'System'
When I locally run the website, it works just fine, but when I uploaded it to the hosting environmen
Logging and nologging bulk insert
Hi,
oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Weird problem with SELECT command..Help!
Hi!
It seems I'm having a really weird problem with SQL SELECT command....I have table into a
AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug
Multi Level Array Problem
hi all,
For example I have array like below:
$temp = array(array('north america', 'us'
MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht
a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload
PHP MySQL Return Results Issue
Hi guys,
I'm running joomla and made a module which is using ajax.
Basically i just have a
Update data to upper case in parent/child tables
Hi Gurus!
In production we have a product table and which is being reference by many tabl
Please help with SMTP Authenticated PHP Email Form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat
