BrighteyesDesign
asked on
Database query not displaying PHP + MySQL
I am trying to display properties from 'Murcia' from the location column of my database.
This is the query i'm trying:
mysql_select_db($database_ PPA, $PPA);
$query_Recordset1 = "SELECT * FROM property WHERE location LIKE 'Murcia'";
$Recordset1 = mysql_query($query_Records et1, $PPA) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Records et1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1 );
But this displays no results, any ideas why?
I have attached a screenshot of the database table...
Screen-shot-2011-08-11-at-14.08..png
This is the query i'm trying:
mysql_select_db($database_
$query_Recordset1 = "SELECT * FROM property WHERE location LIKE 'Murcia'";
$Recordset1 = mysql_query($query_Records
$row_Recordset1 = mysql_fetch_assoc($Records
$totalRows_Recordset1 = mysql_num_rows($Recordset1
But this displays no results, any ideas why?
I have attached a screenshot of the database table...
Screen-shot-2011-08-11-at-14.08..png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER