troubleshooting Question

Php unexplained results form mysql query

Avatar of breeze351
breeze351 asked on
17 Comments2 Solutions507 ViewsLast Modified:
I'm doing a query with php.  The data doesn't exist in the table but mysql_num_rows is returning a count of "1".  Here's the code in question:

// Build Sql query & execute
$Work = str_replace(" ","",$Street);
$SqlString1 = "SELECT * FROM saka WHERE HUH LIKE '$Work%'";
echo "$SqlString1 <br>";
$Saka_File = mysql_query($SqlString1);
$count = mysql_num_rows($Saka_File);

// If no street name
echo "count = $count <br>";

The query is correct.  I'm not sure what this could be.

Also, I'm not sure if this is the correct forum.   I have a login page which displays correctly in Firefox but not in IE.  If you would like to take a look it's "".


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 17 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 2 Answers and 17 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