[SOLVED] while loop

[piotr]

Hi,

 

I have a simple loop which displays records from my database:

 

<? $i=1; while($cdata=mysql_fetch_array($cres)){
     echo "<a href='cat,$cdata[id].html'>".output_fields($cdata['title'])."</a>";
if($i!=$cnum) echo ", "; $i++;
}
?>

 

The loop works fine but it displays all records so there are some repeated things. How can I get only records which diffrent names?

 

Thanks in advance

[trq]

You need to format your query to only retrieve unique results. Can we see your query?

[piotr]

So first I take categories:

 

$csql	="SELECT categories .*  FROM `categories` , category
	WHERE categories.id = category.category_id
	AND category.item_id ='$item_id'";
	$cres  	=	mysql_query($csql);
	$cnum	=	mysql_num_rows($cres);
                $cdatares	=	mysql_query($cdatasql);
	$catdata    =      @mysql_result($cdatares,0,'title');
	$catdataid  =      @mysql_result($cdatares,0,'id');

 

Next I put while loop from first post. Then I put that loop for subcategories. Some items has the same category but diffrent subcategory so it displays category twice

[SetToLoki]

So first I take categories:

 

$csql	="SELECT categories .*  FROM `categories` , category
	WHERE categories.id = category.category_id
	AND category.item_id ='$item_id'";
	$cres  	=	mysql_query($csql);
	$cnum	=	mysql_num_rows($cres);
                $cdatares	=	mysql_query($cdatasql);
	$catdata    =      @mysql_result($cdatares,0,'title');
	$catdataid  =      @mysql_result($cdatares,0,'id');

 

Next I put while loop from first post. Then I put that loop for subcategories. Some items has the same category but diffrent subcategory so it displays category twice

 

$csql	= select distinct category from categories;

[piotr]

Yes, it works.

Thanks guys