retrieving data from mysql having a common value

[kellen]

Maybe I can clarify, by showing a small, sample database (here, comma-delimited):

MAKE, MODEL, PRICE, PRODUCT_LinE
Ford, Escort A, $8999, Ford Escort
Ford, Escort B, $9395, Ford Escort
Ford, Excort C, $10299, Ford Escort
Ford, Escort Z, $12199, Ford Escort
Ford, Mustang A, $18999, Ford Mustang
Ford, Mustang B, $21999, Ford Mustang
Ford, Mustang C, $23999, Ford Mustang
Ford, Mustang Z, $27999, Ford Mustang

i wanna to get all values of Ford Escort and Ford Mustang,but the Ford Escort and Ford Mustang must get only once (or print only once..)....

my result must be like this :

Ford Escort
Ford, Escort A, $8999
Ford, Escort B, $9395
Ford, Excort C, $10299
Ford, Escort Z, $12199

Ford Mustang
Ford, Mustang A, $18999
Ford, Mustang B, $21999
Ford, Mustang C, $23999
Ford, Mustang Z, $27999

-->>>>Hope that clarifies !
please reply.........

[helimeef]

Maybe I can clarify, by showing a small, sample database (here, comma-delimited):

MAKE, MODEL, PRICE, PRODUCT_LinE
Ford, Escort A, $8999, Ford Escort
Ford, Escort B, $9395, Ford Escort
Ford, Excort C, $10299, Ford Escort
Ford, Escort Z, $12199, Ford Escort
Ford, Mustang A, $18999, Ford Mustang
Ford, Mustang B, $21999, Ford Mustang
Ford, Mustang C, $23999, Ford Mustang
Ford, Mustang Z, $27999, Ford Mustang

i wanna to get all values of Ford Escort and Ford Mustang,but the Ford Escort and Ford Mustang must get only once (or print only once..)....

my result must be like this :

Ford Escort
Ford, Escort A, $8999
Ford, Escort B, $9395
Ford, Excort C, $10299
Ford, Escort Z, $12199

Ford Mustang
Ford, Mustang A, $18999
Ford, Mustang B, $21999
Ford, Mustang C, $23999
Ford, Mustang Z, $27999

-->>>>Hope that clarifies !
please reply.........

That's kind of tricky, but I'll try.
Okay let's assume that the databases name that your keeping these values in is "cars".

$allCars = mysql_query("SELECT PRODUCT_LinE FROM cars");
$prod_lines = array();
while($car = mysql_fetch_array($allCars)) {
  $prod_lines[] = $car['PRODUCT_LinE'];
}
$prod_lines = array_flip(array_flip($prod_lines));
 
foreach($prod_lines as $line) {
  echo '<strong>'.$line.'</strong><br />';
  while($lineRows = mysql_fetch_array(mysql_query('SELECT * FROM cars WHERE PRODUCT_LinE = \''.$line.'\'') {
    echo $lineRows['MAKE'].', '.$lineRows['MODEL'].', '.$lineRows['price'].'<br />';
  }
}
 

There's probably a better way to do it then that, but I don't know enough SQL. Give me a buzz if you need any further help or if the script doesn't work.
I'm sure you probably know enough PHP to customize it so that the markup is accessible.