Hello people, i have the following code though it is not giving me the exact results i want. i would like the code to order by the name but the order by doesnt seem to be executed. here is the code;
$query2 = "select * from jos_categories where id = '".$row['cid']."' ORDER BY name ASC"; $result2 = mysql_query($query2, $conn); $idrow = mysql_fetch_assoc($result2); $link = sefRelToAbs('index.php?option=' . $option . '&task=view&limit=0&id=' .$idrow['id'] . '&Itemid=' . $Itemid);
thanx in advance for any help.