Code: Select all
$OrdQry = "select * from product order by Pname";
$ResOrd = mysql_db_query($db,$OrdQry,$cid);
$OrdNum = mysql_num_rows($ResOrd);Code: Select all
$OrdQry = "select distinct * from product order by Pname";
$ResOrd = mysql_db_query($db,$OrdQry,$cid);
$OrdNum = mysql_num_rows($ResOrd);but i want some thing else i want select *(each and evey thing) but i want to apply distinct on only
one field something like this.
Code: Select all
$OrdQry = "select * distinct isbn from product order by Pname";
$ResOrd = mysql_db_query($db,$OrdQry,$cid);
$OrdNum = mysql_num_rows($ResOrd);help please.