database name test_db
database table test_table


<?php

$dbhost = 'localhost';
$dbuser = 'dave';
$dbpass = 'davepass';
$dbname = 'test_db';

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
	or die  ('Error connecting to mysql');


mysql_select_db($dbname);

$result = mysql_query("SELECT user FROM test_table WHERE id=1 AND email=test.test.com");

echo "The user name is: '$result'";


mysql_close($conn);

?>


i get this error


The user name is: 'Resource id #2'