(PHP & MYSQL)
I'm looking for some advice whilst creating my image gallery. I'm using the $_GET to bring the variables I need onto a new page, which will give more details about each product.
My gallery works fine and I then have all the details coming onto the details page, which also works fine... but I have decided I would like to also have "UnitCost" for each item, also displaying on the details page.
I have all the variables displaying on the first page and using $_GET works to display them, except Unit cost, which I want to only display on the details page (as it doesn't need to be in the gallery).
My question is this:
Can I use the mysql query to call the UnitCost on the gallery page (not displaying it anywhere) and then use [ $UnitCost= $_GET; ] to get the variable I need? or do I need to either display it on the gallery page first or write a new MySql statement on the details page?
I hope that makes sense. I'm sure you can tell that I'm a learner but I do try to search for answers before I post here asking for help.
many thanks in advance for help/advice given,