| |
Cookbook Recipes
' ') order by recipes.TXN_TS desc";
$resultrp = mysql_query($sqlrp) or die(mysql_error());
while($myrowrp=MySQL_fetch_array($resultrp)){
$rFirst = ucfirst($myrowrp["First_Name"]) ;
$rLast = ucfirst($myrowrp["Last_Name"]) ;
?>
&fid=" class="blogLinks">
By
|
' ') and (cookbook.ID = (select Max(ID) as lastID from cookbook where User_ID = '$userID'))";
$msg = "This is the last recipe added to $First_Name's Cookbook" ;
if($recid > " "){
$sqlrp = "select users.First_Name, users.Last_Name, recipes.* from recipes,users where (users.ID = recipes.User_ID) and (recipes.ID='$recid')";
$msg = " " ;
}
$resultrp = mysql_query($sqlrp) or die(mysql_error());
if($myrowrp=MySQL_fetch_array($resultrp)){
$recid = $myrowrp["ID"] ;
$rFirst = ucfirst($myrowrp["First_Name"]) ;
$rLast = ucfirst($myrowrp["Last_Name"]) ;
//rating
$sql = "select avg(Rating) as rating from ratings where (For_Recipe_ID ='$recid')";
$result = mysql_query($sql) or die(mysql_error());
if($myrow=MySQL_fetch_array($result)){
$rate = substr($myrow["rating"],0,1) ;
switch ($rate) {
case "1.00":
$image="1";
break;
case "2.00":
$image="2";
break;
case "3.00":
$image="3";
break;
case "4.00":
$image="4";
break;
case "5.00":
$image="5";
break;
default:
$image="3";
}
}
if(($myrowrp["Prep_Time_Hours"] > " ") && ($myrowrp["Prep_Time_Minutes"] > " ")){
$prepTime = $myrowrp["Prep_Time_Hours"]. ":". $myrowrp["Prep_Time_Minutes"] ;
}
if($myrowrp["Prep_Time_Hours"] > " " && $myrowrp["Prep_Time_Minutes"] < " "){
$prepTime = $myrowrp["Prep_Time_Hours"] . ":00" ;
}
if($myrowrp["Prep_Time_Hours"] < " " && $myrowrp["Prep_Time_Minutes"] > " "){
$prepTime = $myrowrp["Prep_Time_Minutes"] . "min" ;
}
if($myrowrp["Total_Time_Hours"] < " " && $myrowrp["Total_Time_Minutes"] > " "){
$totTime = $myrowrp["Total_Time_Minutes"] . "min" ;
}
if($myrowrp["Total_Time_Hours"] > " " && $myrowrp["Total_Time_Minutes"] > " "){
$totTime = $myrowrp["Total_Time_Hours"] . ":" . $myrowrp["Total_Time_Minutes"] ;
}
if($myrowrp["Total_Time_Hours"] > " " && $myrowrp["Total_Time_Minutes"] < " "){
$totTime = $myrowrp["Total_Time_Hours"] . ":00" ;
}
?>
| This recipe was submitted by |
| Prep Time: | Total Time: | Serving Size: |
Current Rating |
 |
Ingredients
Instructions
|
