There are problems again, hey

idiotback

I saved the picture name in the database
There are multiple products sharing the same picture
Such as:

prd_id prd_name prd_pic
1 NOKIA 1 1.gif
2 NOKIA 2 1.gif
3 NOKIA 3 2.gif

How to put 1.gif together when taking out?

hkhotmail

select prd_id, prd_name from Data table where prd_pic = '1.gif' order by prd_id

死骑接班人

select prd_id, prd_name from Data table group by prd_pic order by prd_id

qijun2005

group by prd_pic