include_once "includes/dbConnNew.php"; include_once "includes/loggedOnPop.php"; $recid = $_REQUEST["recid"]; $sqlrp = "select * from recipes where (ID='$recid')"; $resultrp = mysql_query($sqlrp) or die(mysql_error()); if($myrowrp=MySQL_fetch_array($resultrp)){ 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" ; } } ?>
| quick chix | |||||||
|
|||||||
| Ingredients $sqlin = "select * from recipes_ingredients where (Recipe_ID='$recid')"; $resultin = mysql_query($sqlin) or die(mysql_error()); while($myrowin=MySQL_fetch_array($resultin)){ ?> =$myrowin["Amount"]?> =$myrowin["Ingredient"]?> }?> |
|||||||
Instructions =$myrowrp["Instructions"]?> |
|||||||