php:count data from db then show at other page

Question

dear all..i have this data inside DB:

line     model        serial      
fa01     kd-g335ud   105x0001     
fa01     kd-g335ud   105x0002     
fa01     kd-g335ud   105x0003 //up to 20pcs or regardless of the number of goods in the db
fa02     kd-r311ed   105x0001
fa02     kd-r311ed   105x0002 //up to 20pcs or regardless of the number of goods in the db

i want if every "model" have reached 20 pcs or regardless of the number of goods in the db, the data will appear at quantity page like:

line     model      qty
fa01    kd-g335ud    20
fa02    kd-r311ed    20

please help, thanks before :-)

Jim · Accepted Answer · 2010-07-29 03:59:35Z

2

SELECT line, model, count(serial) as qty FROM table_name GROUP BY line, model

Not 100% sure on my query, but that is along the lines of what you want. Hopefully that query is correct!

answered Jul 29, 2010 at 3:59

Jim

18.9k5 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

klox Over a year ago

after the result appear, how to ditribute the result to the quantity page?

Jim Over a year ago

Through using the php mysql functions? For a tutorial on how to do this: siteground.com/tutorials/php-mysql/display_table_data.htm (not sure on the quality of that tutorial).

Neo · Accepted Answer · 2010-07-29 04:19:10Z

0

you are not explaining it well. you said "i want if every "model" have reached 20 pcs or regardless of the number of goods..." what about the line. regardless of the line or in regards :)? If you want every model regardless of the line and serial then:

SELECT model, count(model) AS QUANITY FROM [table name] GROUP BY model;

answered Jul 29, 2010 at 4:19

Neo

11.7k4 gold badges71 silver badges81 bronze badges

Collectives™ on Stack Overflow

php:count data from db then show at other page

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related