My table has about half a million rows, and when I call queries like
$query = "SELECT * FROM people WHERE last_name='$last'";
no results are returned. However when I use LIMIT (without WHERE), as in the following line of code, 25 results are returned.
$query = "SELECT * FROM people LIMIT 25";
I also tried checking the status on my table through phpmyadmin, and it said it was okay. Next, in an effort to isolate the problem, I created a new table with just 1 row, and tested the query directly, and 1 result was returned. What could be the problem?
