Member Avatar for jayhall

In php group by then min group row show fist,

please help,

  • 2 Contributors
  • 4 Replies
  • 82 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by jayhall
Member Avatar for pritaeas

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

Member Avatar for jayhall

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

Member Avatar for pritaeas

Show your code (and use code tags).

Member Avatar for jayhall 
$sql = " 
SELECT name,surname,date,sold,MIN(price) as prices FROM clienttable WHERE ref= 'may' GROUP BY name ";
Edited by jayhall because: n/a
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.