[Regicide]

All I am trying to do is put in a varible in a mysql query in PHP. This is what I have now:

PHP Code:

$page = $_GET['view'];
$db = mysql_connect("localhost", "root", "pass");
mysql_select_db("test", $db);
$query = "SELECT title FROM pages where page = '$page'";
$title = mysql_query("$query", $db); 


For some reason this returns the value "resource id #2". But, when I use the same command in command line, it works fine. $page contains the right text, I've checked. Can someone please help me?

[clr]

has the $page variable already been assigned a value? That might cause a problem if it hasn't yet

[Regicide]

It holds the correct text. To make sure, I did printf("$page"). But other than that, it wasn't initalized until the $page = $_GET['view'].

[clr]

hmm...i'm stumped....maybe try re-working some of your php...maybe capitalize the "WHERE" that could possibly cause probs with the SQL