Fantastic.

Thanks.

Is there a big difference between Varchar and Text?

Sorry.

Additionally, what's the best method of storing a true or false value?

Thanks.

Hi all,

I'm having one of those horrible dilemas, when setting up a mySQL database. There are so many data types to choose from these days, I'm unsure of which ones to choose. Obviously I want to choose the most accurate and efficient type for each field.

My main concern is for fields that will contain text. There are so many options, varchar, text, blob etc.

I am setting up a customer database with name, address, telephone etc. I would be swayed towards using Varchar for them all. Would this be right?

Also, would you use Varchar or a numeric field for telephone number?

Thanks,

Nick.

I would create a Cart class, that stores an array of Product ID's and Quantity.

Everytime a customer buys a product it gets added to the array in the Cart class.

When the customer views cart, you loop through the array to display the correct product info.

Nick.

Hey thanks.

That makes sense.

Thanks again,

Nick....

Hi,

How is it possible to reference objects between pages?

Everytime I leave a page, my object no longer exists.

Do I need to write them to Session variables?

Thanks,

Nick.