No idea what this means.

[coldspirit]

I use something like this:

$host="localhost";
$root="root";
$pass="password";
mysql_connect($host,$root,$pass);
mysql_select_db("test");
if(!mysql_connect("localhost","root","password")){
echo "You fail.";
}
else {
echo "success<br/>";
}
$DaBook = mysql_query("SELECT title FROM books WHERE ID=1");
echo $DaBook;

It doesn't give me the content of cell, but some strange string:
"Resource id #2"

What am I doing wrong? The result should be returned as a string, since the content of cell is String type.
When I do this inside the database the result is given as expected, but when I use mysql_query(...) it returns some bull****.

Thank you, A.J.

[jgetner]

you should never save your database info in the same script..... now you forgot to use mysqli_fetch() or mysqi_fetch_assoc() will allow you to get the results you are seeking.

on a side note: use die() with a mysql_error() to check for connection failure.

[Pikachu2000]

mysql_query() returns a result resource. That must then be accessed with one of: mysql_result(), mysql_fetch_row(), mysql_fetch_assoc(), mysql_fetch_array(), etc.

$DaQuery = "SELECT `title` FROM `books` WHERE `ID`=1";
if( $DaResult = mysql_query($DaQuery) ) {
     $DaRow = mysql_fetch_assoc($DaResult);
     echo $DaRow['title'];
} else {
     echo "<br>DaQuery dat failed wuz: $DaQuery<br>Wif da errorz: ". mysql_error() . '<br'>';
}