Mysql gurus in here
 

Folks I imported about 20k rows into my table. Some rows show, some do not. Here's the funky part. If I go into an entry and save it (even if I change no data) it will show when I "select *"
I figured it was the query cache so I reset it. That didn't do it. How can I get all of the entries to show?

it would help to know how are you viewing the data? the command line? phpMyAdmin? your own script?

$result = mysql_query("select * from myTable where category = '".$insertCat."' && approved = 1 limit 5");

php

you have a limit set to 5?

Yeah, no kidding. That's not what is causing it. I have 20 categories. 1,000 entries per. some categories display 0 results despite the limit.

I should reiterate it is not a cache issue. I have run mysqladmin flush-tables and it clears everything. Even reloaded.

Maybe a problem with $insertCat variable?

plus, get into the habit of putting backticks around your query:

SELECT * FROM `myTable` WHERE `category` = '".$insertCat."' AND `approved` = 1 LIMIT 5;

trust me - there are lots of words in mysql syntax that if used as a row/table description would cause headaches.

Negative. Can't be that because I can echo the var just fine when pulling it into my function. It's something mysql related.

I wouldn't blame MySQL just yet. It's pretty damn hard to tell what's wrong with 1 php line and a somewhat vague description of the problem.

Well, as you know, the sql syntax is ok (although I didn't know you could use '&&' - I've always used 'AND'), so all I can say, it has to be something weird with the var.

If this isn't an if loop, then just echo the sql query, and run it in mysql at the command line (or phpmyadmin) and see if the output matches your scripts...

btw, the cache never borks like that - it hashes the mysql table and if the table has changed since the last cache, the cache is deleted and the query goes directly to mysql