BradM

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?

borked

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

__________________

For coding work - hit me up on andy // borkedcoder // com
(consider figuring out the email as test #1)

BradM

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

php

Adultnet

you have a limit set to 5?

__________________


TrafficCashGold Paying Webmasters Since 1996!
Awesome Conversions! Fast Weekly Payments! Over 125 Tours!

BradM

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.

BradM

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

borked

Maybe a problem with $insertCat variable?

__________________

For coding work - hit me up on andy // borkedcoder // com
(consider figuring out the email as test #1)

borked

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.

__________________

For coding work - hit me up on andy // borkedcoder // com
(consider figuring out the email as test #1)

BradM

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

xenilk

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.

__________________
40$/Page PSD->XHTML/CSS Transformations

borked

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...

__________________

For coding work - hit me up on andy // borkedcoder // com
(consider figuring out the email as test #1)

borked

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

__________________

For coding work - hit me up on andy // borkedcoder // com
(consider figuring out the email as test #1)