what's effective way of doing it
Posted: Thu Sep 14, 2006 11:36 pm
is there better way of doing it
$query = "SELECT matrimonial.matri_id,matrimonial.nationality,matrimonial.caste,matrimonial.aboutme FROM matrimonial,category where(matrimonial.caste=category.cat_id and category.main_cat=6) order by matrimonial.views desc limit 1";
may be from maximum..may be that way only one row will be quried
rather than sorting all
i tried but am confused in its syntax,
if i use max does it return only maximum number of views (ie number)
but i want all the fields vale of max views row
$query = "SELECT matrimonial.matri_id,matrimonial.nationality,matrimonial.caste,matrimonial.aboutme FROM matrimonial,category where(matrimonial.caste=category.cat_id and category.main_cat=6) order by matrimonial.views desc limit 1";
may be from maximum..may be that way only one row will be quried
rather than sorting all
i tried but am confused in its syntax,
if i use max does it return only maximum number of views (ie number)
but i want all the fields vale of max views row