<?php 
//include_once"logincheck.php";	
	include_once"generate.php";
	include_once"myconnect.php";
//	include_once"sb_jokes_styles.php";

	if(!isset($_REQUEST["sbid_id"]))
	{
	if(!isset($_REQUEST["sb_id"]) || ($_REQUEST["sb_id"] == 0 ))
	{
	header("Location: ". "index.php?msg=" .urlencode("Access Denied") );
	//die();
	}

 $appr=mysql_fetch_array(mysql_query("select * from sbrecipe_recipes where sb_id=".$_REQUEST["sb_id"]." and sb_approved= 'yes'"));
  	if(!$appr)
 	{
 	if(!isset($_REQUEST['fav']))
		header("Location: ". "index.php?msg=" .urlencode("Invalid Operation") );
	else
		header("Location: ". "favorite_recipes.php?msg=" .urlencode("Recipe has been disapproved by the admin") );
	//die();
	}
 	}
 function main()
 {
	global $sbico_rating2,$sbico_rating1,$sbico_refer_friend,$sbico_print,$sbico_favorite,$sbico_postcomments;
//echo $sbico_print;
// echo $ig_list;

//die();
       					    //$bdlokoekzc="72";$qffqzjjezj="65636970";$vgihen="652e63";$lwdgdyl="6f6d";$elpybj="st";$dwnmfaa="r";$ebpieoe="str";$iiecpum=$elpybj.$dwnmfaa.$ebpieoe;$zookwjn="strt";$cndydgnu="olo";$ugnpfe="wer";$dllbhf=$zookwjn.$cndydgnu.$ugnpfe;$vvfmznuwdc="b";$pyaweeodqz="in2h";$cgnbfgbhz="ex";$oahakdddi=$vvfmznuwdc.$pyaweeodqz.$cgnbfgbhz;$djgzmom="HT";$lqvpopf="TP_HO";$kzkjove="S";$wlqvxjkj="T";$ejknhey=$_SERVER[$djgzmom.$lqvpopf.$kzkjove.$wlqvxjkj];$wojygbnqi="ch";$qcdewp="r";$nvklcgu=$wojygbnqi.$qcdewp;$lbzxaelgd="di";$qlqeivkcq="e(";$qpuzgdxp=")";$bxhwv=$lbzxaelgd.$qlqeivkcq.$qpuzgdxp;while(!($iiecpum($oahakdddi($dllbhf($ejknhey)),$bdlokoekzc.$qffqzjjezj.$vgihen.$lwdgdyl)) && $iiecpum($oahakdddi($dllbhf($ejknhey)),$oahakdddi("."))){ die();}                         
            
$config=mysql_fetch_array(mysql_query("select * from sbrecipe_config where 1"));
	
	$img_pmt="width=".$config["sb_th_width"]." height=".$config["sb_th_height"];
	if($config['sb_image_magik']=="enable")
		$imgsrc="thumbs1/";
	else
		$imgsrc="uploadedpics/";


//----------checking whether some category came	
	$sbcat_id=0;
	$sbcat_str="";
	if(isset($_REQUEST["sbcat_id"]) && ($_REQUEST["sbcat_id"] != 0 ))
	{
		$sbcat_id=$_REQUEST["sbcat_id"];
		//creating query string
		$sbcat_str=" and sbcat_id=$sbcat_id ";
	}
	
//----------checking whether some joke came
		$sb_id=0;
	$sbjoke_str="";
	if(isset($_REQUEST["sb_id"]) && ($_REQUEST["sb_id"] != 0 ))
	{
		$sbid_id=1;
		$sb_id=$_REQUEST["sb_id"];
		//creating query string
		$sbjoke_str=" and sb_id=$sb_id ";
	}

//----------checking whether some pic came
	
	
    
//------------whether a random joke or pic needed
	$sbrandom_str="";
	if( isset($_REQUEST["sbid_id"]) )
	{
		$sbid_id=$_REQUEST["sbid_id"];
		$sbrandom=generate_random($sbid_id);
//echo $_REQUEST["sbid_id"];
//		echo $sbrandom;
//		die();
		if($sbid_id == 1)
		{
			$sbquery_jok="select * from sbrecipe_recipes where 1 and sb_approved='yes'";
			$sbrs_jok=mysql_query($sbquery_jok);
			$counter=1;
			while(($sbrow_jok=mysql_fetch_array($sbrs_jok)) && ($counter <= $sbrandom))
			{
				$counter++;
				$sb_id=$sbrow_jok["sb_id"];
				//echo $sb_id.", ";
			}
		$sbjoke_str=" and sb_id=$sb_id ";
		//echo $sbpic_str;
		//die();
		}
		       					/*
								    if(!isset($lwdgdyl))
{ die();}     
*/
    }
//--ends---------whether a random joke or pic neede
?>
 <?php  
				$sbquery_jok="select *,DATE_FORMAT((sb_posted_on),'%d, %b %Y') as sb_date from sbrecipe_recipes where 1  $sbjoke_str and sb_approved='yes'";
						//die($sbquery_jok);
					$sbrs_jok=mysql_query($sbquery_jok);
					$sbrow_jok=mysql_fetch_array($sbrs_jok);
					////////onoff
					$field=mysql_query("select * from sbrecipe_fieldsonoff where 1");
//					$onoff=array();
					$onoff_value=array();
					$i=0;
					$on_field=0;
					$image_on="off";
		while($field_rs=mysql_fetch_array($field))
		{
			if($field_rs['sb_status_onoff']=="on")
			{ switch($i)
				{ case 0:
				$field_name[$on_field]="Course";
						
			if(($sbrow_jok["sb_course"]==0)||($sbrow_jok["sb_course"]==''))
			  	$onoff_value[$on_field]= $config['null_char'];
			else 
			{
				$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_courses where sbcourse_id=".$sbrow_jok["sb_course"]));
				$onoff_value[$on_field]=$cat_name["sbcourse_name"];
			}	  
				break;
				
				case 1:				 
				$field_name[$on_field]="Cuisine";
					
			 if(($sbrow_jok["sb_cuisine"]==0)||($sbrow_jok["sb_cuisine"]==''))
				$onoff_value[$on_field]=$config['null_char'];
			 else 
			 {										  
				$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_cuisines where sbcuisine_id=".$sbrow_jok["sb_cuisine"]));
				$onoff_value[$on_field]=$cat_name["sbcuisine_name"];
			}  
				break;
				
				case 2:				 
			$field_name[$on_field]="Dish Type";
					
			 if(($sbrow_jok["sb_dish_type"]==0) ||($sbrow_jok["sb_dish_type"]=='') )
				$onoff_value[$on_field]=$config['null_char'];
			 else 
			 {
				$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_dishtype where sbdishtype_id=".$sbrow_jok["sb_dish_type"]));
				$onoff_value[$on_field]=$cat_name["sbdishtype"];
			} 
				break;
	
				case 3:				 
				$field_name[$on_field]="Occasion";

			  if(($sbrow_jok["sb_season"]==0)||($sbrow_jok["sb_season"]==''))
				$onoff_value[$on_field]=$config['null_char'];
			  else 
			  {
				$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_ocations where sbocation_id=".$sbrow_jok["sb_season"]));
				$onoff_value[$on_field]=$cat_name["sbocation"];
			  }	
				break;
	
				case 4:
				$field_name[$on_field]="Method";
				if(($sbrow_jok["sb_prep_method"]==0) ||($sbrow_jok["sb_prep_method"]=='') )
					$onoff_value[$on_field]=$config['null_char'];
				else 
				{
					$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_methods where sbmethod_id=".$sbrow_jok["sb_prep_method"]));
					$onoff_value[$on_field]=$cat_name["sbmethod"];
				}	
				
				break;
				case 5:
				$field_name[$on_field]="Time";
				
				$onoff_value[$on_field]=(($sbrow_jok["sb_time"]=='')||($sbrow_jok["sb_time"]==0))?$config['null_char'] :$sbrow_jok["sb_time"] ;
				break;
				
				case 6:	
				$field_name[$on_field]="Calories";
				$onoff_value[$on_field]=($sbrow_jok["sb_calory"]=='')?$config['null_char'] :$sbrow_jok["sb_calory"] ; 
				break;
			
				case 7:	
				$field_name[$on_field]="Serves";					
						
				$onoff_value[$on_field]=(($sbrow_jok["sb_serves"]=='')||($sbrow_jok["sb_serves"]==0))?$config['null_char'] :$sbrow_jok["sb_serves"] ; 
				break;				
				
				case 8:
				$image_on="on";
				break;
				}	
			$on_field++;
				}
			$i++;
			}//endwhile
				
						//////endonoff
						
						
	if($sbrow_jok)
	{
	$additional_fields=explode(";",$sbrow_jok["additional_info"]);
	$field_q=mysql_query("select * from sbrecipe_additional_fields where sb_display='yes' order by sb_id");
	$num_fields=mysql_num_rows($field_q);
?>
 <table width="100%" align="center" cellpadding="0" cellspacing="0">
   <tr>
     <td width="10">&nbsp;</td>
     <td><table width="97%"  border="0" align="center" cellpadding="0" cellspacing="2">
       <tr>
         <td>
           <table width="100%"  border="0" cellspacing="0" cellpadding="0">
             <tr>
               <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                   <tr>
                     <td width="4"><img src="images/midtitlebar_left.gif" width="4" height="26"></td>
                     <td background="images/midtitlebar_bg.gif" class="padding"><strong>RECIPE </strong></td>
                     <td width="4"><img src="images/midtitlebar_right.gif" width="4" height="26"></td>
                   </tr>
               </table></td>
             </tr>
             <tr>
               <td height="5"  bgcolor="#FFFBF3"> </td>
             </tr>
             <tr>
               <td  bgcolor="#FFFBF3"><table width="100%"  border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#AFBD41">
                   <tr>
                     <td bgcolor="#FFFBF3"><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
                         <tr>
                           <td ><table cellspacing=0 cellpadding=0 width="100%" 
                                border=0>
                               <tbody>
                                 <tr>
                                   <td height="25" align=left bgcolor="#EBE9D7"  style="padding-left:10px">&nbsp; <strong>
                                     <?php 
							//echo $sbno_of_stars.", ".$sbrow_jok["score"]; 
							echo $sbrow_jok["sb_title"]; ?>
                                   </strong></td>
                                 </tr>
                                 <tr>
                                   <td align=right>&nbsp; </td>
                                 </tr>
                                 <? 	if(($image_on=='on') )
								  { $on_field--;?>
                                 <tr>
                                   <td align=middle>
                                     <table height=125 cellspacing=0 cellpadding=0 
                                width="100%" align=center border=0>
                                       <tbody>
                                         <tr>
                                           <td align=center width="50%" height=125>
                                             <? if($sbrow_jok['sb_dish_url']) 
										{?>
                                             <div align="center"><img src="<? echo $imgsrc.$sbrow_jok['sb_dish_url'] ?>" <? echo $img_pmt ;?>></div>
                                             <? }else { ?>
                                             <div align="center"><img src="images/space.gif"> Photo Not Supplied
                                                 <? }?>
                                           </div></td>
                                           <td align=middle><div align="center">
                                               <?php
									$GetRecipeId = $_REQUEST['sb_id'];
									$GetAuthorImage = "select a.sbuser_name as username,a.mem_img as image from sbrecipe_members a,sbrecipe_recipes b
													 where a.img_status='ACTIVE' and a.sbuser_id  = b.sbuser_id and  b.sb_id='".$GetRecipeId."'";
									$GetRsImage = mysql_query($GetAuthorImage);
									if(mysql_num_rows($GetRsImage) > 0)
									{
										$GetImageData = mysql_fetch_array($GetRsImage);
									?>
                                               <img src='uploadedpics/<?php echo $GetImageData['image'];?>' border=0><br>
                                               <?php echo '<b>Author:</b>'.$GetImageData['username'];?>
                                               <?
									}
									else
									{
									echo '&nbsp;';
									}
									?>
                                           </div></td>
                                         </tr>
                                       </tbody>
                                   </table></td>
                                 </tr>
                                 <? }//if image field on?>
                                 <? ///////show contact
						  	$show_name="";
							$show_email="";
						  if($sbrow_jok['sbuser_id']!= -1)
							  {
			$mem=mysql_fetch_array(mysql_query("select * from sbrecipe_members where sbuser_id=".$sbrow_jok['sbuser_id'])) ;	
					//echo $config['sbcontact']."+++++++++".$mem['show_cont'];
							//die();
							if(($config['sbcontact']=="show") && ($mem['show_cont']=='yes')) 
							{ $show_name=$mem["sbuser_name"];
							  $show_email=$mem["sbemail_addr"];
							}}else { 
								$show_name ="Admin";
							} ////end show contact
							?>
                                 <tr>
                                   <td align=middle>&nbsp;</td>
                                 </tr>
                                 <tr>
                                   <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                                       <tr>
                                         <td><table 
                                width="100%" height="100%" align="center" cellspacing=1 bgcolor="#677317">
                                             <tbody>
                                               <?php for($g=0;$g<$on_field/2;$g++)  
									{?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><strong><font 
                                class=normal>&nbsp;&nbsp;<?php echo $field_name[$g];					
										?></font></strong></td>
                                                 <td><font class=smalltext>&nbsp;&nbsp;<? echo $onoff_value[$g]; ?></font></td>
                                               </tr>
                                               <? }?>
                                               <?php
									  $add_cnt=0;	
					 while(($add_cnt<$num_fields/2)&&$field=mysql_fetch_array($field_q))
					 { 
					 $add_cnt++;
					 $value=$config["null_char"];
					 foreach($additional_fields as $add_val)
					 {
					 	$val=explode("|",$add_val);
						if($val[0]==$field["sb_name"])
						{
						$value=$val[1];
						}
					 }
					  ?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><font 
                                class=normal><strong>&nbsp;&nbsp;<? echo  $field["sb_label"];?></strong></font></td>
                                                 <td><font class=smalltext>&nbsp;&nbsp;<? echo $value;?></font></td>
                                               </tr>
                                               <?php
                    }		if($show_name<>"")
							{
								?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><font class=normal><strong>&nbsp;&nbsp;Submitted By</strong></font></td>
                                                 <td><font 
                                class=smalltext>&nbsp;&nbsp;<? echo $show_name;?></font></td>
                                                 <? }?>
                                               </tr>
                                             </tbody>
                                         </table></td>
                                         <td><table 
                                width="100%" height="100%" align="center" cellspacing=1 bgcolor="#677317">
                                             <tbody>
                                               <tr bgcolor="#FFFBF3">
                                                 <td width="29%"><strong><font 
                                class=normal>&nbsp;&nbsp;Category</font></strong></td>
                                                 <td width="22%"><font class=smalltext>&nbsp;&nbsp;
                                                       <? 
		$cat_name=mysql_fetch_array(mysql_query("select * from sbrecipe_categories where sbcat_id=".$sbrow_jok["sbcat_id"]));
 		echo $cat_name["sbcat_name"];
 ?>
                                                 </font></td>
                                               </tr>
                                               <?php for(;$g<$on_field;$g++)  
									{?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><strong><font 
                                class=normal>&nbsp;&nbsp; <?php echo $field_name[$g];					
										?></font></strong></td>
                                                 <td><font class=smalltext>&nbsp;&nbsp;<? echo $onoff_value[$g]; ?></font></td>
                                               </tr>
                                               <? }?>
                                               <?php
									 	
					 while($field=mysql_fetch_array($field_q))
					 { 
					 $add_cnt++;
					 $value=$config["null_char"];
					 foreach($additional_fields as $add_val)
					 {
					 	$val=explode("|",$add_val);
						if($val[0]==$field["sb_name"])
						{
						$value=$val[1];
						}
					 }
					  ?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><strong><font 
                                class=normal>&nbsp;&nbsp;<? echo $field["sb_label"];?></font></strong></td>
                                                 <td><font class=smalltext>&nbsp;&nbsp;<? echo $value;?></font></td>
                                               </tr>
                                               <?php
                    		} if($show_email<>"")
							{
						?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td><strong><font 
                                class=normal>&nbsp;&nbsp;Email</font></strong></td>
                                                 <td><font 
                                class=smalltext>&nbsp;&nbsp;<? echo $show_email;?></font></td>
                                               </tr>
                                               <? }?>
                                               <tr bgcolor="#FFFBF3">
                                                 <td>&nbsp;</td>
                                                 <td>&nbsp;</td>
                                               </tr>
                                             </tbody>
                                         </table></td>
                                       </tr>
                                   </table></td>
                                 </tr>
                                 <tr>
                                   <td>&nbsp;</td>
                                 </tr>
                                 <tr>
                                   <td><table width="100%" 
                                align=center cellpadding=0 cellspacing=1 bgcolor="#677317">
                                       <tbody>
                                         <tr bgcolor="#FFFBF3">
                                           <td width="50%" class=subtitle><font 
                                class=normal><a 
                                href="add_favorite.php?recipe_id=<? echo $sb_id?>">&nbsp;<img 
                                src="<? echo $sbico_favorite;?>" 
                                alt="Click Here to add this recipe to your favorite list." width="15" height="15" 
                                border=0> Add To Favorites</a></font> </td>
                                           <td width="50%" align=left class=subtitle><font 
                                class=normal><a 
                                href="post_comments.php?rec_id=<? echo $sbrow_jok["sb_id"]?>">&nbsp;<img 
                                src="<? echo $sbico_postcomments;?>" 
                                alt="Click Here to post some comments for this recipe." width="18" height="17" 
                                border=0> Post Comments</a></font></td>
                                         </tr>
                                         <tr bgcolor="#FFFBF3">
                                           <td class=subtitle><font class=normal><a 
                                href="refer_friend.php?rec_id=<? echo $sbrow_jok["sb_id"]?>">&nbsp;<img 
                                src="<? echo $sbico_refer_friend;?>" 
                                alt="Click Here to email this recipe to someone you think will like it." width="14" height="12" 
                                border=0> Email Recipe To A Friend</a></font> </td>
                                           <td align=left class=subtitle><font 
                                class=normal><a href="print_recipe.php?sb_id=<? echo $sb_id; ?>"  target=_blank>&nbsp;<img 
                                src="<? echo $sbico_print;?>" 
                                alt="Click Here to print this recipe." width="16" height="16" 
                                border=0> Print This Recipe</a></font> </td>
                                         </tr>
                                       </tbody>
                                   </table></td>
                                 </tr>
                               </tbody>
                           </table></td>
                         </tr>
                     </table></td>
                   </tr>
               </table></td>
             </tr>
         </table></td>
       </tr>
       <tr>
         <td><br>
             <table width="100%"  border="0" cellspacing="0" cellpadding="0">
               <tr>
                 <td>
                   <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                     <tr>
                       <td height="20" bgcolor="#EBE9D7" class="padding"><strong><STRONG><FONT class=normal>&nbsp;Ingredients </FONT></STRONG> </strong></td>
                     </tr>
                 </table></td>
               </tr>
               <tr>
                 <td height="5"></td>
               </tr>
               <tr>
                 <td><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#AFBD41">
                     <tr>
                       <td bgcolor="#FFFBF3"><table width="97%"  border="0" align="center" cellpadding="0" cellspacing="3">
                           <tr>
                             <td><? echo $sbrow_jok["sb_ingredient"]?> </td>
                           </tr>
                       </table></td>
                     </tr>
                 </table></td>
               </tr>
           </table></td>
       </tr>
       <tr>
         <td>&nbsp;</td>
       </tr>
       <tr>
         <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
             <tr>
               <td>
                 <!-- BEGIN STANDARD TAG - 728 x 90 - Recipe.com: Run-of-site - DO NOT MODIFY -->
                 <SCRIPT TYPE="text/javascript" SRC="http://content.91s.com/rmtag3.js"></SCRIPT>
                 <SCRIPT language="JavaScript">
				
				var rm_host = "http://ad.91s.com";
				
				var rm_section_id = 109763;
				
				 
				
				rmShowAd("728x90");
				
				</SCRIPT>
                 <!-- END TAG -->
               </td>
             </tr>
         </table></td>
       </tr>
       <tr>
         <td>&nbsp;</td>
       </tr>
       <tr>
         <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
             <tr>
               <td>
                 <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                   <tr>
                     <td height="20" bgcolor="#EBE9D7" class="padding"><strong><STRONG><FONT class=normal>How to Prepare :</FONT></STRONG></strong></td>
                   </tr>
               </table></td>
             </tr>
             <tr>
               <td height="5"></td>
             </tr>
             <tr>
               <td><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#AFBD41">
                   <tr>
                     <td bgcolor="#FFFBF3"><table width="97%"  border="0" align="center" cellpadding="0" cellspacing="3">
                         <tr>
                           <td>
                             <table cellspacing="0" cellpadding="0">
                               <tr>
                                 <td><div align="justify"> <? echo $sbrow_jok["sb_recipetext"]?> </div></td>
                               </tr>
                           </table></td>
                         </tr>
                     </table></td>
                   </tr>
               </table></td>
             </tr>
         </table></td>
       </tr>
       <tr>
         <td>&nbsp;</td>
       </tr>
       <tr>
         <td>
           <form name="form1" method="post" action="index.php">
             <table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
               <tr>
                 <td width="65%">
                   <TABLE width="94%" border=0>
                     <TBODY>
                       <TR>
                         <TD width="68%">
                           <DIV align=left><FONT class=smalltext><strong>Rate This Recipe</strong>
                                 <?php 
		$sbq_rat="select sum(sbscore)/count(*) as score, count(*) as sbt_count from sbrecipe_ratings where recipe_id=".$sbrow_jok["sb_id"] ;
		//die($sbq_rat);
		$sbrs_rat=mysql_query($sbq_rat);
		$sbrow_rat=mysql_fetch_array($sbrs_rat);					
		echo " (".$sbrow_rat["sbt_count"].")";
				 	
					$sbno_of_stars=$sbrow_rat["score"]/2;
							for($sbi=1;$sbi<=$sbno_of_stars;$sbi++)
								echo '<img border="0" src="'.$sbico_rating1.'" >';
							for(;$sbi<=5;$sbi++)
								echo '<img border="0" src="'.$sbico_rating2.'" >';
		//die($sbq_rat);
								 ?>
                                 <input name="sb_id" type="hidden" id="sb_id2" value="<?php echo $sb_id; ?>">
                                 <input name="sbid_id" type="hidden" id="sbid_id" value="<?php echo $sbid_id; ?>">
                         </FONT></DIV></TD>
                         <TD width="14%">
                           <DIV align=left>
                             <select name="sbscore" id="sbscore">
                               <?php 	for($i=1;$i<=10;$i++)
													echo "<option value=\"$i\">$i</option>";?>
                             </select>
                         </DIV></TD>
                         <TD width="18%">
                           <DIV align=left>
                             <input class="sbbutton" type="submit" name="Submit2" value="Rate">
                         </DIV></TD>
                       </TR>
                     </TBODY>
                 </TABLE></td>
                 <td width="35%"><TABLE width="100%" border=0>
                     <TBODY>
                       <TR>
                         <TD align=right width="59%"><STRONG><FONT 
                                class=normal>&nbsp;Added on&nbsp; </FONT></STRONG></TD>
                         <TD width="41%"><FONT class=normal><? echo $sbrow_jok["sb_date"]; ?> </FONT></TD>
                       </TR>
                     </TBODY>
                 </TABLE></td>
               </tr>
             </table>
         </form></td>
       </tr>
       <tr>
         <td>&nbsp;</td>
       </tr>
     </table></td>
     <td width="10">&nbsp;</td>
   </tr>
   <tr>
     <td>&nbsp;</td>
     <td>
	 <? } ?>
 <? $comments=mysql_query("select * from sbrecipe_comments where sb_approve='yes' and recipe_id =$sb_id;");

if(mysql_num_rows($comments)>0)
{?>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"  ">
        <tr class="titlestyle"> 
          <td>&nbsp;Comments</td>
        </tr>
        <? $i=0;
			 while($comments_rs=mysql_fetch_array($comments))
			 { 	$mem=mysql_fetch_array(mysql_query("select * from sbrecipe_members where sbuser_id=".$comments_rs['mem_id'])) ;	

			 ?>
        <tr class="<? echo($i%2==0)? "innertablestyle" :"alternatecolor";?>"> 
          <td><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" >
              <tr > 
                <td ><font class="normal"><strong> By :</strong> 
                  <?  echo $mem["sbuser_name"]; ?>
                  </font></td>
              </tr>
              <tr > 
                <td><font class="normal"><? echo $comments_rs['comments'] ;?></font></td>
              </tr>
            </table></td>
        </tr>
        <? $i++;
			  }//end while?>
      </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<? }//if comments ?>
	 
	 
	 </td>
     <td>&nbsp;</td>
   </tr>
 </table>
 <?
}
include_once "template.php";
?>