why does my query always return 0

[seanpaulcail]

here's my query

mysql_select_db("a0017855");
$query = "select * from Eli
where '.page_name.'='.$page_name1.'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

Page_name1 is the name of a select box on the search page which posts to the results.php page which has the code above.

I have a collumn named page_name, in a table named Eli.

I've tried many different things, but I can't get the query comparision to work.

Any ideas?

Thanks

[seanpaulcail]

zmysql_select_db("a0017855");
$query = "select * from Eli
where page_name = '$page_name1'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

do not put the column name or row name in quotes. Only the variable you are passing goes in quotes

[stolzyboy]

you can also you backticks on your field names if you really want to

ie.

where fieldname = 'value'