Greetings All,
Being new to this list I beg indulgence in a matter that has me quite
befuddled.
Having already had good success in building my first database web site
I was taken aback when I ran across his little problem whist checking
things out for full functionality on a 7500+ item database;-)
Using the below statement results in a null data dump:
SELECT * FROM items WHERE item = '109S2' AND venturi_type =
'L-shaped' AND category = 'burner';
Whereas if change the 'S' in the item = 10902 like this:
SELECT * FROM items WHERE item = '10902' AND venturi_type =
'L-shaped' AND category = 'burner';
I get a full complete data dump. Both numbers are legitimate part
numbers in the item column yet one works the other does not.
I have the 'item' column data type set to VARCHAR(30) btw! I am using
phpMyAdmin-2.5.3 to check this all out.
What am I missing here? Any help would be greatly appreciated!
Tommy Barrios
WEBZIGHT.COM
http://www.webzight.com
If you've got a good thing going, don't fix it!
