A question about how a quote is stored

A question about how quotes are stored
Learn to write your first PHP program there's a place where you don't know how to design a database,



Quotation information is dynamically increased, each increase of a quote, will add 1 price, a quantity, a note, it is not possible to each field in the database set up a separate field, should be in what way exist 1 database fields, use the time and then extract the format, but do not know the idea of implementation!

How can this be better stored in the database? Also to facilitate the subsequent extraction of quotations for the high and low comparison.




------Solution--------------------
Picture hangs, pass csdn again map
Why is it impossible to put prices, quantities, notes in three separate fields?
To be stored in a field can be serialized or processed into JSON to deposit, take out the time to process the corresponding array
------Solution--------------------
ID INT (8) UNSIGNED not NULL auto_increment,
PRODUCTS_ID (8) NOT NULL,
Price varchar (TEN) is not NULL,
Quality INT (7) is not NULL,
Text varchar (255) is not NULL,

ID | products_id | Price | Quality | Text

1 | 1 | 15.00 | 25 | Note
2 | 1 | 15.60 | 30 | Note
...


SELECT * FROM table where products_id= ' 1 ' ORDER by ID limit 1. Remove the last updated, product number 1.
SELECT * FROM table where products_id= ' 1 ' Remove all product number 1
------Solution--------------------
Key=>value
------Solution--------------------
This can be stored in the form of a serialized array, which is removed when needed to restore the array.
Serialize ()

