My company are making a CD-ROM with a load of links to websites on it. As the CD-ROM cannot be amended once it's been sent to our customers, we need a way of keeping the websites up-to-date.
I had the bright idea of creating a MySQL database table with two columns: 'Weblink' and 'nWeblink'.
'Weblink' would hold the current website http reference and 'nWeblink' would initially be set with nothing in it. If for some reason one of the website dies, we would then enter a new similar website in 'nWeblink'.
What I want to do is direct a link from the CD-ROM to a PHP page on my company's website, get the PHP to check if the website is still active (i.e. there is nothing in 'nWeblink') and then go on to redirect to the correct website.
I have successfully set my RecordSet ($Recordset1) using Dreamweaver, but now I need to code the above with PHP?
Can anyone help?
Thanks in advance