isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> 0) { $names=split(",",$flag); $aname=strip_and_quote($_GET['authid']); $sql="select fldAuthorNarratorId from TBL_Author_Narrator_Master where fldTopicName='".$aname."'"; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); if($row[0]!='') $_GET['authid']=$row[0]; } } $authorid=$_GET['authid']; if($authorid=="") $authorid=$_POST['id']; $subcatid=$_GET['subcatid']; if($subcatid=="") $subcatid=$_POST['subcatid']; $sql="select * from TBL_Author_Narrator_Master where fldAuthorNarratorId=".$authorid; $rs=$db->ReturnRs($sql); $row_topic=mysql_fetch_object($rs); $authorname=trim($row_topic->fldFirstName.' '.$row_topic->fldLastName); $authorurl=$row_topic->fldAuthorNarratorUrl; // done for wimpy setting $atitle=str_replace("'","",trim($authorname)); $atitle=str_replace('"','',$atitle); $atitle=str_replace('#','hashproblem',$atitle); // end $dlink=$row_topic->fldDisplayedUrl; $title_dlink=""; if(strlen($dlink) > 23) { $title_dlink=$dlink; $dlink=substr($dlink,0,24)."..."; } $forlink = str_replace(" ","-",trim($authorname)); $thumbnailimage=$row_topic->fldThumbnailImage; $aimage=$row_topic->fldImage; $shortdesc=(stripslashes($row_topic->fldAuthorShortDescription)); $longdesc=(stripslashes($row_topic->fldAuthorLongDescription)); $totalproduct=$row_topic->fldTotalProduct; $heresample=$row_topic->fldHereSample; if(substr_count($heresample,'.mp3')==0) $hflag=1; else $hflag=2; $authorflag=$row_topic->fldAuthorNarratorFlag; $allhref=""; if($row_topic->fldKeywords!='') { $meta_content_arr=explode("\n",$row_topic->fldKeywords); for($i=0;$ifldAuthorShortDescription); $meta_desc=stripslashes($meta_desc); $meta_desc=str_replace('"','',$meta_desc); if(empty($meta_desc)) $meta_desc=$authorname." Audio Books, Podcasts, and Free Downloads on LearnOutLoud.com."; $title=$row_topic->fldTitleTag; if($title=="") $title=$authorname." Audio"; $author_href='http://www.learnoutloud.com/Resources/Authors-and-Narrators/'.add_and_hyphen($authorname).'/'.$authorid; if($authorflag==0) $atype="Author"; else if($authorflag==1) $atype="Narrator"; else $atype="Author & Narrator"; if(substr($authorurl,0,7)!="http://" && $authorurl!='') $authorurl="http://".$authorurl; if($authorurl!='') { $author_url=" "; $author_url1="".$dlink.""; } else $author_url="".$dlink.""; if($catid!="") $allhref=$author_href; else if($subcatid!="") $allhref=$author_href; else $allhref="#".add_and_hyphen($authorname); //search criteria if($subcatid!="") { $sql="select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in(".$subcatid.") and fldcatSubCatId<>0 and fldCatSubCatFlag=1"; $rs=$db->ReturnRs($sql);$i=0; while($row=mysql_fetch_array($rs)) { if($id_list!='') $id_list.=",".$row[0]; else $id_list=$row[0];$i++; } if($id_list=="") $id_list=0; } if($_POST['hidFormatFlag']==1) { //print_r($_POST); $chkOnlineAudio=""; $chkOnlineVideo=""; $chkAudioDownload=""; $chkVideoDownload=""; $list_a_v=explode(":",$_POST['hidFormatList']); $list_a=$list_a_v[0]; if($list_a==17) $chkAudioDownload="checked"; $list_v=$list_a_v[1]; $arr_a=explode(",",$list_a); $arr_v=explode(",",$list_v); if(in_array("102",$arr_a) || in_array("103",$arr_v)|| in_array("101",$arr_a)|| in_array("13",$arr_a)) { $listA21=$listA22=$listV2=$whereAV2=""; if(in_array("102",$arr_a)) { $chkOnlineAudio="checked"; $sqlA22="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='Audio CD'"; $rsA22=$db->ReturnRs($sqlA22); $rowA22=mysql_fetch_object($rsA22); $listA22=$rowA22->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listA22'"; } if(in_array("103",$arr_v)) { $chkVideoDownload="checked"; $sqlVD2="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='Audio Cassette'"; //print "
sqlVD2 :: $sqlVD2 "; $rsVD2=$db->ReturnRs($sqlVD2); $rowVD2=mysql_fetch_object($rsVD2); $listVD2=$rowVD2->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listVD2'"; } if(in_array("101",$arr_a)) { $chkOnlineVideo="checked"; $sqlV2="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='MP3 CD'"; $rsV2=$db->ReturnRs($sqlV2); $rowV2=mysql_fetch_object($rsV2); $listV2=$rowV2->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listV2'"; } if(in_array("13",$arr_a)) { $chkOnlineAudio="checked"; $sqlA22="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName = 'Online Audio'"; $rsA22=$db->ReturnRs($sqlA22); $rowA22=mysql_fetch_object($rsA22); $listA22=$rowA22->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listA22'"; } // 10/23/2008 listA21 listA22 listV2 listVD2 $sel_format_list="-1"; if(!empty($listA21)) $sel_format_list.=",".$listA21; if(!empty($listA22)) $sel_format_list.=",".$listA22; if(!empty($listV2)) $sel_format_list.=",".$listV2; if(!empty($listVD2)) $sel_format_list.=",".$listVD2; if($sel_format_list!="-1") $whereAV2="and (TBL_Format_Master.fldFormatId IN($sel_format_list))"; //print " whereAV2 :: $whereAV2"; //$sqlAV2="select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage from TBL_Product_Master,TBL_Product_Format_Detail,TBL_Format_Master where TBL_Product_Master.fldProductId=TBL_Product_Format_Detail.fldProductId and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and TBL_Product_Master.fldFreeFlag!=1 and fldLearnSectionFlag IN('0','2') and TBL_Product_Master.fldKidsSectionFlag!=1 $whereAV2"; $sqlAV2=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage from TBL_Product_Master,TBL_Product_Format_Detail,TBL_Format_Master where TBL_Product_Master.fldProductId=TBL_Product_Format_Detail.fldProductId and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and TBL_Product_Master.fldFreeFlag!=1 and fldLearnSectionFlag IN('0','2') and TBL_Product_Master.fldKidsSectionFlag!=1 $whereAV2"; $rsAV2=$db->ReturnRs($sqlAV2); $list_pro_ids_AV2=""; while($rowAV2=mysql_fetch_object($rsAV2)) { if($list_pro_ids_AV2!="") $list_pro_ids_AV2 .=",".$rowAV2->fldProductId; else $list_pro_ids_AV2 =$rowAV2->fldProductId; } }//end of second if // covered format 2 if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids_AV2!="") { $list_pro_ids.=$list_pro_ids_AV2; } if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } else { //$avlist=makelist($db); //$list_a_v=explode(":",$avlist); // $list_a=$list_a_v[0]; // $list_v=$list_a_v[1]; if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } $where_con .=" and ( fldAbridgedUnabridgedFlag =1 or fldAbridgedUnabridgedFlag =0 ) "; } } //ascending combos if($_POST['subcat_prodlist']!='') $where_con .=" and PM.fldProductId in (".$_POST['subcat_prodlist'].") "; $selType=$_POST['selType']; if($selType=="") // $selType=17; //deffualt id avarage member rating $selType=4; //deffualt id avarage member rating // echo $selType; switch($selType) { case 1: $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldProductTitle1 asc"; //echo "Here".$sql_final_query; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldProductTitle1 asc" ; } break; case 2: $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldProductTitle1 desc"; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") ".$where_con." order by fldProductTitle1 desc" ; } break; case 3: //Authur Name $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldLastName,fldFirstName"; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldLastName,fldFirstName" ; } break; case 4: //Avg. Member ratings avg(fldRatingPoints) as average //$sql_final_query="select distinct PM.fldProductId,avg(fldRatingPoints) as average,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM left join TBL_Review_Rating TRR on PM.fldProductId=TRR.fldProductId,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldPublishFlag=1 and PAN.fldFeaturedProductFlag=1 and PM.fldProductId=PAN.fldProductId and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." group by PM.fldProductId order by average desc , PM.fldProductTitle asc"; //Most Popular $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldRelevanceCount DESC, fldProductTitle1 asc"; //echo "Here".$sql_final_query; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldRelevanceCount DESC,fldProductTitle1 asc" ; } break; case 5: //featured $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PAN.fldFeaturedProductFlag=1 and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldFirstName,fldLastName"; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") and TBL_Product_Author_Narrator.fldFeaturedProductFlag=1 and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' ".$where_con." order by PM.fldProductTitle"; } break; default: //default $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldProductId=PAN.fldProductId and PM.fldPublishFlag=1 and PAN.fldAuthorNarratorId='".$authorid."' ".$where_con." order by fldProductTitle1"; if($subcatid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") and TBL_Author_Narrator_Master.fldAuthorNarratorId='".$authorid."' ".$where_con." order by PM.fldProductTitle1" ; //echo $sql_final_query; } break; } //get total number of product irrespective $sql_count_query="select distinct PM.fldProductId from TBL_Product_Master PM,TBL_Product_Author_Narrator PAN,TBL_Author_Narrator_Master ANM where ANM.fldAuthorNarratorId=PAN.fldAuthorNarratorId and PM.fldPublishFlag=1 and PM.fldProductId=PAN.fldProductId and PAN.fldAuthorNarratorId='".$authorid."' order by fldProductTitle1"; $result_count=$db->ReturnRs($sql_count_query); $product_count = mysql_num_rows($result_count); //echo $sql_final_query; $result=$db->ReturnRs($sql_final_query); $count = mysql_num_rows($result); $p = new Pager; if($_POST['selCount']==1) { $limit = 10; } else if($_POST['selCount']==2) { $limit = 25; } else if($_POST['selCount']==3) { $limit = 50; } else if($_POST['selCount']==4 || $_POST['selCount']==6) { $limit = $count; } else { $limit = 10; } $start = $p->findStart($limit,$pageno); if($count!= 0 ) $pages = $p->findPages($count, $limit); $pagelist = $p->pageList($pageno, $pages,1); $pagelist_top = $p->pageList($pageno, $pages,0); $j=1+($pageno-1)*$limit; $start_count=$j; //***************************************************************/ //echo "->".$sql_final_query; $rs_pro_idsForVideo=mysql_query($sql_final_query); $vflag = "0"; //$getQu = mysql_query($rs_pro_idsForVideo); while($fetchQu = mysql_fetch_assoc($rs_pro_idsForVideo)) { //echo "==>".$fetchQu[fldProductId]; $getVid = "select fldFormatId from TBL_Product_Format_2_Detail where fldProductId ='".$fetchQu[fldProductId]."' "; $getVideo = mysql_query($getVid); while($fetchVideo = mysql_fetch_assoc($getVideo)) {//echo "--->"; //print_r($fetchVideo); $isVideo = in_array("11",$fetchVideo); if($isVideo == "1") { $vflag = "1"; } } } //echo "------>".$vflag; $select_pro_ids=$sql_final_query." LIMIT ".$start.", ".$limit; $rs_pro_ids=$db->ReturnRs($select_pro_ids); //........................................................... ?> isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> <? echo $title;?>

          

0){?> "; ?>Go to Audio Downloads

Sort by
Titles Per Page
- ($start_count+$limit-1)) echo $start_count+$limit-1 ; else echo $count ; ?> of Titles
0 then only show edition $select_version="select fldProductId from TBL_Product_Other_Version where fldProductId=".$row_pro_ids->fldProductId; $rs_version=$db->ReturnRs($select_version); $version_count=mysql_num_rows($rs_version); if($subcatid!='') if($subcat_prodlist!="") $subcat_prodlist.=",".$row_pro_ids->fldProductId; else $subcat_prodlist=$row_pro_ids->fldProductId; if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); $format=get_available_formats($db,$row_pro_ids->fldProductId);?>
.
fldProductId; //$href=generate_href($db,$row_pro_ids->fldProductId); if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); if($_POST['selCount']!=6) { ?>
fldProductId); display_image($row_pro_ids->fldProductThumbnailImage,$serverpath1.'/'.$pthumbnailimage.$row_pro_ids->fldProductThumbnailImage,0,0,"",$href,"",$row_pro_ids->fldProductTitle,"",$sample); ?>
by
Available on:
fldShortDescription!='') { ?>

fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[0]=0; if($HTMLFlags[0]==0) echo nl2br($row_pro_ids->fldShortDescription); else echo $row_pro_ids->fldShortDescription; ?>

- ($start_count+$limit-1)) echo $start_count+$limit-1 ; else echo $count ; ?> of Titles

Featured In

Format

<? echo $title;?>
location.href='podcast_results.php?fname=$searchtxt';"; } ?>
LOL
 

<?=$authorname?>
ReturnRs($sql_free_pid); $row_free_pid=mysql_fetch_row($rs_free_pid); $result_free_pid=$db->ReturnRs($select_pro_ids); $count_free_pid = mysql_num_rows($result_free_pid); if($count_free_pid>0) { ?>

Description

Browse Titles

0 then only show edition $select_version="select fldProductId from TBL_Product_Other_Version where fldProductId=".$row_pro_ids->fldProductId; $rs_version=$db->ReturnRs($select_version); $version_count=mysql_num_rows($rs_version); if($subcatid!='') if($subcat_prodlist!="") $subcat_prodlist.=",".$row_pro_ids->fldProductId; else $subcat_prodlist=$row_pro_ids->fldProductId; if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); $format=getresponsive_available_formats($db,$row_pro_ids->fldProductId); if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); $sample=displayresponsivepagi_sample($db,$row_pro_ids->fldProductId); ?>
fldProductTitle ?>
by
fldAbridgedUnabridgedFlag==1 && $version_count>0){?>
Unabridged Edition
fldAbridgedUnabridgedFlag==0 && $version_count>0){?>
Abridged Edition
fldShortDescription!='') { ?>

fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[0]=0; if($HTMLFlags[0]==0) echo nl2br($row_pro_ids->fldShortDescription); else echo $row_pro_ids->fldShortDescription; ?>