In php group by then min group row show fist,

please help,

Recommended Answers

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

Jump to Post

All 4 Replies

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

Show your code (and use code tags).

$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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.