Ive tryed using the following code to get data from the MySQL table...

<?php

$connection=mysql_connect("localhost","USERNAME","PASSWORD"); 
    $db=mysql_select_db("darkWkyr",$connection); 

$check_name = "SELECT Name FROM profiles WHERE id=1";
$users_name = mysql_query($check_name);


echo "Name : $users_name";

?>

But instead of displaying the name which should be 'JAmes' it displays 'Resource id #3'...

Whys this??? I have made an error in the code???

Thanks

-James

Yes, yes you have

When you get the value from mysql_query, what it gives you (as you can see) is a resource ID. You then use this ID for other things. To get actual values from a resource, you've got to use the other mysql functions.

PHP Code:

$conx = mysql_connect('localhost', 'USERNAME', 'PASSWORD') or die('Error while connecting to db server');
mysql_select_db('darkWkyr', $conx) or die('Error while selecting db');

$result = mysql_query("SELECT Name FROM profiles WHERE id=1", $conx);

$users_name = mysql_fetch_row($result);
$users_name = $users_name[0]; // mysql_fetch_row returns an array. we only want the Name so we just set it excluseively.

echo "Name : $users_name"; 


See these:
http://ca3.php.net/manual/en/functio...etch-array.php
http://ca3.php.net/manual/en/functio...-fetch-row.php
http://ca3.php.net/manual/en/functio...etch-assoc.php

Thanks

-James