Hi,
Isn't @docName a MySQL variable? That means it is not the same as the column docName in your table and when the variable is updated, the column does not change. You would need to store it in a particular row in a table in the next SQL statement for your method to work. More details at [
dev.mysql.com].
Regards,
toivo
Sydney, Australia