In php group by then min group row show fist,

please help,

Give an example of your data and expected output. Show some code too.

i need to by group which fine but start show by MIN(price) in all group,

example
id name price
5 johan 55
1 smith 70
2 wil 85
plase help

$sql = " 
SELECT name,surname,date,sold,MIN(price) as prices FROM clienttable WHERE ref= 'may' GROUP BY name ";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.