select distinct not working

[2stroke]

I am trying to do something like this in a php script but I can't get it to work when I put distinct in there. What am I doing wrong?

If I run it from the command line it works fine.
mysql> select distinct category from products;

$query  = "select distinct category from products";
$result = mysql_query($query);

if ($result)
{
  while($row = mysql_fetch_row($result))
   {
    $name     = $row[0];
    $desc      = $row[1];
    $price      = $row[2];
    $category = $row[3];

    echo "Category : $category <br>";
   }
}

 

[argh01]

your php is wong
each entry across is a row. So you need this:

if ( $result ) {
while ( $row=mysql_fetch_row( $result ) ) {
  $name=$row[0];
  echo "Category: $name<br />";
 }
}

Take whatever shortcuts you want in there.
You're only takin the categories in the select part of the statement, so you only have one column in each row. $row[0] will be the only one with any data. And you will get x number of rows each with one column.

 

[2stroke]

Got it thanks
+rep

 

[1timedeal]

You can test your output the next time for easier debug. very efficient and I use it all the time.

$query = "select distinct category from products";
$result = mysql_query($query);

if ($result)
{
while($row = mysql_fetch_row($result))
{

echo"<pre>";print_r($row);echo"</pre>";
}
}