Hello
I need to know if this would be easy to implement, or if it's even possible and if so how.
I have a mysql database table named prices. Inside is a field named "name" which every entry is unique. the second field is named price.
I need to somehow pull the price field out of the database and insert it on the detailed pages in Links SQL.
I know nothing about writing mysql statements or php etc. But here is what I would like it to do in laymans wording
Select from table prices where name equals <%cardname1%> and
bring back field price from where name equals <%cardname1%>
I want to somehow make it so that on the detailed html pages of links sql it will place the price from the row where the name equals the same thing as what is written in my detailed.html files (basically <%cardname1%> etc.
I hope that all makes sence.
That might all be confusing, basically I want to pull a fields data out of my price database and have it inserted into the detailed pages that gets written by Links sql, there is a field named "name" in the price database and it has the same name that I can get links sql to print out on my detailed pages when I use the tag <%cardname#%> (where # is replaced with a real number from 1 to 60 as determined by when the person added their record in in my links sql database to begin with)
I need to know if this would be easy to implement, or if it's even possible and if so how.
I have a mysql database table named prices. Inside is a field named "name" which every entry is unique. the second field is named price.
I need to somehow pull the price field out of the database and insert it on the detailed pages in Links SQL.
I know nothing about writing mysql statements or php etc. But here is what I would like it to do in laymans wording
Select from table prices where name equals <%cardname1%> and
bring back field price from where name equals <%cardname1%>
I want to somehow make it so that on the detailed html pages of links sql it will place the price from the row where the name equals the same thing as what is written in my detailed.html files (basically <%cardname1%> etc.
I hope that all makes sence.
That might all be confusing, basically I want to pull a fields data out of my price database and have it inserted into the detailed pages that gets written by Links sql, there is a field named "name" in the price database and it has the same name that I can get links sql to print out on my detailed pages when I use the tag <%cardname#%> (where # is replaced with a real number from 1 to 60 as determined by when the person added their record in in my links sql database to begin with)