Hi there, Im totally new to mySql and am playing about with it to try and optimize a site that Im working on at the moment. It is a script based website generated from a .sql file that I have been modifying to improve SEO. I have managed to do most of what I want, but when at the moment it is creating pages (for each record) with the pagename being the primary key (integer) and I would like to exchange this for the record title (another field). I have installed a mysql server to have a look at the data, and tried to manually change it in excel (essentially copying the record title over the key field), but cant get the data connected. I have also had a look to see if its governed by the php, which it could be, but if it is I cant find it. I feel like Im going cross-eyed here with this and any help that anyone could shed on it would be appreciated. If anyone needs a sample of the data, or php files or just a link to the site let me know, Im unsure what would be needed so I didnt want to post it all. thanks again!
Just to further quantify, when I say the "pagename" is the primary key, I mean the URL or address that is being generated for the page is the primary key - a numeric value: SO, my page titles are like 001.html and I would rather it was RECORD_TITLE.html thanks for any help peeps! MOG
Hi, I'm happy to have a look at this and see if I can help. You probably need to post more detail before I can give any useful info though! Richard