How is it possible that I can run a simple query such as: SELECT * FROM jcost WHERE JOB_ID = 7855; and get (x) number of records. When I run the same query through PHP code written several years ago I get more records (x + n). Are these extra records in cache and SQLyog is only looking at data written to a table (not in cache)? How do I get the extra rows of data? Flush?
Who is Participating?
Rob_JeffreyConnect With a Mentor IT/ProgrammingCommented:
If you are getting different results I would suspect that the PHP code is accessing a different server or database or even table.

There should be nothing such as cache that would skew the numbers as you've described.
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
I agree with Rob.  If phpMyAdmin is available on the correct server, try running your query there.  You should get the same results as running directly against MySQL.

How many records are you talking about and how much difference?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.