georgebates Posted November 28, 2009 Share Posted November 28, 2009 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: <!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> Link to comment https://forums.phpfreaks.com/topic/183199-code-doesnt-print-what-i-wanted-it-too-please-help/ Share on other sites More sharing options...
trq Posted November 28, 2009 Share Posted November 28, 2009 Take a look at mysql_fetch_assoc and its related docs. Link to comment https://forums.phpfreaks.com/topic/183199-code-doesnt-print-what-i-wanted-it-too-please-help/#findComment-966835 Share on other sites More sharing options...
georgebates Posted November 28, 2009 Author Share Posted November 28, 2009 HI Thorpe, as i said before I am new to PHP and don't really understand much of that. Would you be able to show how to use it? Thanks Link to comment https://forums.phpfreaks.com/topic/183199-code-doesnt-print-what-i-wanted-it-too-please-help/#findComment-966836 Share on other sites More sharing options...
georgebates Posted November 28, 2009 Author Share Posted November 28, 2009 AH right. I read that site that you linked to but I dont understand how to get it to just read from the row that has the username that matches to the one entered by the user. Thanks Link to comment https://forums.phpfreaks.com/topic/183199-code-doesnt-print-what-i-wanted-it-too-please-help/#findComment-966850 Share on other sites More sharing options...
trq Posted November 28, 2009 Share Posted November 28, 2009 I'm sure the manual is quite clear. if ($result = mysql_query("SELECT `password` FROM users WHERE username = '$username'")) { if (mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); echo $row['password']; } } Link to comment https://forums.phpfreaks.com/topic/183199-code-doesnt-print-what-i-wanted-it-too-please-help/#findComment-966865 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.