Well im storing it for amazon affiliates product links. I can't afford to generate the links on the spot as I will have to generate many of them on my website. so i stored them in a database for quicker access. I just want to know the best data type to store it in. Right now im using longtext and its working but just wanted to know the best one. Thanks

Atli, on 15 March 2012 - 07:58 PM, said:

Thanks!

Does it matter which method I use? Or is it just preference. And for the first two methods will i just have to put that at the top of my first page and the other pages will be able to run queries? And last question how would I be able to close the connection after the user quits the page because mysql_close() won't work on mysql_pconnect and I'm assuming the other ones too.

Thanks for the suggestion but the meta tags didn't work. Here is the basics of my code. Maybe I am doing something wrong.

ChangeLocation.php

$query = mysql_query("**HERE I UPDATE THE PERSONS REGION**")
header("location: home.php");
exit;

Home.php

$query = mysql_query("**GET THE NEW INFORMATION**")

in the html I just echo out the info but it only shows the new info when i refresh the page
This is at the top of the page for all the web pages. And I am using sessions if that helps with anything.

Yes, my website needs that. Every book that is stored is to a particular city. So when the user searches a keyword in the city he has chosen it will only pop up those books posted in that city. I also want to save the users location. And thank you so much that diagram helped me a lot . I guess that makes the most sense and seems the most efficient. So making a database for each country is out of the question I am a beginner at database design so any advice would be appreciated.