<?php mysql_connect("localhost", "uName", "passwd") or die(mysql_error());
mysql_select_db("dbName") or die(mysql_error());
$query = mysql_query("SELECT ingredients, title, date FROM dbName ORDER BY date");
while(($recipe = mysql_fetch_assoc($query)) !== false){
$rIngredients = $recipe['ingredients'];
$rTitle = $recipe['title'];
$rDate = $recipe['date'];
$date = date("F jS, Y"); ?>
<p>Add to database:</p>
<form action="" method="POST">
<input type="text" name="title" />
<textarea name="ingredients" rows="5" cols="20"></textarea><br />
<input type="submit" name="submit" value="Update" />
</form>
<?php
if(isset($_POST['submit'])){
$query2 = "UPDATE dbName SET ingredients = '".$_POST['ingredients']."', title = '".$_POST['title']."', date = '$date'";
mysql_query($query2);
}
}
?>