Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of BrighteyesDesign

ASKER

Perfect, thanks!