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!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
