Jump to content

Archived

This topic is now archived and is closed to further replies.

Btown2

PHP Newb Here

Recommended Posts

Just wondering how i can pull data out of my DB. Heres what i attempted so far, but it returns "Resource id#4"


[code]<?php
include "mysql_connect.php";

$username=$_POST['namebox'];
$entered_password=$_POST['pbox'];

$query ="SELECT password FROM users WHERE (name = \"$username\")";

$password = mysql_query($query);

echo $password;

?>[/code]

Share this post


Link to post
Share on other sites
[code=php:0]
$username=$_POST['namebox'];
$entered_password=$_POST['pbox'];

$query ="SELECT password FROM users WHERE name = '$username' LIMIT 1";

//mysql_query will execute your SQL query and return the resource
$result = mysql_query($query);

//then you need to use a query function to retrive all the rows based on your query result
list($password) = mysql_fetch_row($result);

//output your password
echo $password;

[/code]

Share this post


Link to post
Share on other sites
You'll probably want to iterate through the result set:

while( list($password) = mysql_fetch_row($result) ) {
echo $password;
}

Share this post


Link to post
Share on other sites

×

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.