As long as you don't have a UNIQUE index on it.
Something else is happening in your code that is putting out the HTML I would guess.
P.S. It should be SELECT * FROM jspCart_products; (your table, not your database)
B Wiley Snyder wrote:
Hello, hope this is the right list....
I created a table with the following code
CREATE TABLE jspCart_products ( ProductID int primary key, CategoryID int, ModelNumber varChar(75), ModelName varChar(250), ProductImage varchar(250), UnitCost decimal(9,2), Description BLOB, );
The CategoryID has duplicate entrys. When I use SELECT * FROM <mydatabase> I see the categories just fine but when they are sent to an html page they are null values. Would that be a screw-up in my code or is it becuase I need to specify when I initially build the table like above that it uses duplicates? i hope that makes sense and thanks for replys in advance.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
