Digital Prescription SQL PHP, using 'LIKE' 'WHERE' and 'FROM' difficulties

[fleetlord]

I am doing a personal project on medical prescriptions. I've reassigned my requirements to host a patients database common to all registered doctors. Doctors are able to fetch patients info incl prescription field, would it be difficult to keep copy of old prescriptions or should I simply overwrite/replace?The same patient database must be accessed by chemists/pharmacies by looking up patients ID and reading out the prescription field for provisioning medication as prescribed.. Anything in particular I should be looking at guys 'parameters' or 'commands' for getting close to the solution?I'm finding it difficult formulating the search option for a doctor to fetch a patients info, despite going in depth through three different stack threads here on 'LIKE' command.Also to have chemists only read access whilst doctr have the ability to write prescriptions.. any ideaThe concept of digital prescriptions..enrollsCheers, Iain