0){ $fld = mysql_fetch_array($qry); $return = $fld[0].""; }else{ $return="Our Products"; } mysql_free_result($qry); return $return; } function spec_name($speid){ $sql = "SELECT spec_detail FROM tbl_spec WHERE spec_id = $speid"; $qry = mysql_query($sql); if (mysql_num_rows($qry)>0){ $fld = mysql_fetch_array($qry); $return = $fld[0].""; }else{ $return=""; } mysql_free_result($qry); return $return; } function gen_f_link($parent){ $sql = "SELECT row_id FROM tbl_gen WHERE parent = ".$parent." ORDER BY rank LIMIT 0,1"; $qry = mysql_query($sql); if (mysql_num_rows($qry)>0){ $fld = mysql_fetch_array($qry); $return = $fld[0]; }else{ $return=0; } mysql_free_result($qry); return $return; } ?>