MYSQL query Doubt VERY INTRESTING?????

[rajmohan]

-------------------------

price  name

---------------------------

  aa           one

  bb           two

  cc              one

  dd           two

  ee              two

  ff                two

----------------------------

 

I want out put as

 

---------

sample

----------

  one

  aa

  cc

  two

  bb

  dd

  ee

  ff

--------

 

Any one guess it with

 

[Psycho]

<?php

$query = "SELECT name, price FROM table ORDER BY name, price";
$result = mysql_query($query) or die (mysql_error());

$current_name = "";

while ($record = mysql_fetch_assoc($result)) {

    if ($record['name'] != $current_name) {
        $record['name'] = $current_name;
        echo "$current_name<br>\n";
    }
    echo "$record['price']<br>\n";
}

?>

[trq]

You might want to read the Howto ask... link in my signature. Your post is bordering on ridiculous.