troubleshooting Question

Database query not displaying PHP + MySQL

Avatar of BrighteyesDesign
BrighteyesDesignFlag for Afghanistan asked on
PHPMySQL Server
2 Comments1 Solution252 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros