An easier way?

I made a database for my wife to store her recipes and a php form that will allow her to put them into the database.

I have a php page that will display the recipes according to the title or name of the recipe. The title or name that is displayed is also a link to a php script that will display that recipe. Here’s an example of the php script:

[B]<?
include(“top.php”)
?>

<?
$query=”SELECT * FROM recipes WHERE category=’Casseroles’ AND name=’Chicken and Rice Casserole'”;
?>

<?
include(“bottom.php”)
?>[/B]

[B]The problem[/B]: I’m having to write a new php script for each new recipe and link to it in order to display a recipe.

Is there a better way of doing this so that it is completely user friendly and will not require involvement on my part outside of the initial setup?

She has bunches and bunches of recipes folks – so please help if you can.

Thanks,
David

Also in #PHP _↴