Search form

slideshow

$qrystring ="SELECT fm.filename,fsi.field_slide_img_alt,fsi.field_slide_img_title , fan.field_author_name_value ,nb.body_value ,wb.field_website_url_value ,bb.field_buy_book_value ,n.title FROM dr_file_managed fm,dr_field_data_field_slide_img fsi , dr_field_data_field_author_name fan ,dr_field_data_body nb ,dr_field_data_field_website_url wb ,dr_field_data_field_buy_book bb ,dr_node n , dr_field_data_field_rank fr WHERE fid = field_slide_img_fid and fsi.entity_id=fan.entity_id and fsi.entity_id=nb.entity_id and fsi.entity_id=wb.entity_id and fsi.entity_id=bb.entity_id and fsi.entity_id=n.nid and fsi.entity_id=fr.entity_id and n.status=1 order by fr.field_rank_value asc";
//echo $qrystring;
$result = db_query($qrystring);
echo "