HTML link to External site Using Values in Table
I am trying to create a hyperlink from the values in a html table.
This is what I have so far:
CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c='`column header name4`,'&PFC='`column header name5`,','`column header name6`,'&PCN='`column header name7`,'target = new> name of link on card </a>')
However, I have a syntax error but can't seem to find it.
Any suggestions? I know I am missing something? Does anyone know if there is a limit on the amount of columns that can be concat for a hyperlink.
Any assistance would be greatly appreciated.