Link to home
Start Free TrialLog in
Avatar of BrighteyesDesign
BrighteyesDesignFlag for Afghanistan

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_Recordset1, $PPA) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$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
Avatar of Rik-Legger
Rik-Legger
Flag of undefined image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BrighteyesDesign

ASKER

Perfect, thanks!