Don't show duplicates on Mysql result

[Julian]

Hi guys

I have this query:

$colname_sub_select = $row_front['id_packages'];
mysql_select_db($database_bb, $bb);
$query_sub = sprintf("SELECT id_sub, nights, status, id_packages FROM sub_packages WHERE id_packages = %s AND status=1 ORDER BY nights ASC", $colname_sub_select);
$sub = mysql_query($query_sub, $bb) or die(mysql_error());
$row_sub = mysql_fetch_assoc($sub);
$totalRows_sub = mysql_num_rows($sub);

The column nights could have the same same number on many rows.

What I'm trying to do is a query that prints the results without the duplicates.

Thanks for the help.... always great answers here. :)

[Eugene]

[quote author=Julian link=topic=114876.msg467509#msg467509 date=1163458890]
Hi guys

I have this query:

$colname_sub_select = $row_front['id_packages'];
mysql_select_db($database_bb, $bb);
$query_sub = sprintf("SELECT DISTINCT id_sub, nights, status, id_packages FROM sub_packages WHERE id_packages = %s AND status=1 ORDER BY nights ASC", $colname_sub_select);
$sub = mysql_query($query_sub, $bb) or die(mysql_error());
$row_sub = mysql_fetch_assoc($sub);
$totalRows_sub = mysql_num_rows($sub);

The column nights could have the same same number on many rows.

What I'm trying to do is a query that prints the results without the duplicates.

Thanks for the help.... always great answers here. :)

[/quote]

That should do it.