I have set up a small MySQL database in which you can search for recipes by an advanced search form. The results are summarised, showing the title and I made the title an <A HREF..> hyperlink to another PHP script which displays the desired formatted recipe.
I wanted to avoid making multiple database connections and I use one connection and sending the information as URL encoded to the final script.
Everything works great but is it better to make a second MySQL connection to grab the full data and send an ID only to the script ? (The URL header looks a bit of a mess although it works well and there's no sensitive data).
I don't want to use a form with hidden vars since hyperlinking is easier and neater in this case.
Any advice would be much appreciated.
Michael
I wanted to avoid making multiple database connections and I use one connection and sending the information as URL encoded to the final script.
Everything works great but is it better to make a second MySQL connection to grab the full data and send an ID only to the script ? (The URL header looks a bit of a mess although it works well and there's no sensitive data).
I don't want to use a form with hidden vars since hyperlinking is easier and neater in this case.
Any advice would be much appreciated.
Michael