MySQL and random errors

jacko115

Hello,

I just started programming PHP and MySQL after I set up a personal web server on my computer. I thought I would test it out with this simple script I wrote. The script is:
<?

$bob = "jack";
$user2pass="hjhjhjhj";
$conn = mysql_connect("localhost", "jacko115", "jf3118");
$query = "SELECT passwd FROM users where userid = '$bob'";
mysql_select_db("test", $conn);
$user2pass = mysql_query($query, $conn);
echo "Hello $bob. Your current password is $user2pass. Thank you for using me.";
mysql_close($conn);
?>

Everything seems to work apart from the fact that it returns:
Hello jack. Your current password is Resource id #2. Thank you for using me.
Instead of:
Hello jack. Your current password is yeapee. Thank you for using me.

Can anyone help me out?

keith73

please read about using vbcode in the forums before you post your code.
http://www.phpbuilder.com/board/misc.php?s=&action=bbcode

try reading the bible first
http://us4.php.net/mysql_query

as for your code, mysql_query just returns a resource identifier. this ID is how mysql references your query.
next you have to use either mysql_result or mysql_fetch_row(),mysql_fetch_array(), etc.

read up on those mysql functions, they'll save you time and may just save your life.

keith

Shrike

I find it funny that your thread title is 'MySQL and random errors'. 99% of the time the random error is the fault of the programmer, not the system 😉