I've been scratching my head for hours over this. It just doesn't make any sense!
This doesn't work, it finds 0 rows...
$query = "SELECT * FROM tblprojectors WHERE brand = 'IBM'";
but this does...
$query = "SELECT brand FROM tblprojectors";
None of the other brand names work either, but all the other columns work fine.
However this works... (if you use the second query)
and you'll find IBM listed with all the other brand names..?
What am i missing?
I'll post more code if needed.