Hi I have a table in a mysql database and I add edit and delete records. The records are simply a pdf which is a report that is updated regularly. The table is indexed on id. Every time a record is added to the database, the id changes.
I have clients who want to automate the download of this report and have asked me to make sure that it is the same address every day even though the pdf changes. The address at the moment is [url removed, login to view] for example
What I want is to amend the table and amend the php to maybe index on name (I will take advice on this) I can have it that there is only one pdf i.e. one record ever on the system. Maybe when the new record is being added that the old one gets deleted.
Is anyone is interested please pmb me and I will show you the system. That will make it easier to understand.