PHP Newb Here

[Btown2]

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]

[extrovertive]

[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]

[fenway]

You'll probably want to iterate through the result set:

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