Gossamer Forum
Quote Reply
Is this possible?
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)

Last edited by:

Westin: Apr 19, 2009, 10:32 PM
Subject Author Views Date
Thread; hot thread Is this possible? Westin 11052 Apr 19, 2009, 10:16 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10916 Apr 20, 2009, 12:35 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10891 Apr 20, 2009, 10:47 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10899 Apr 21, 2009, 12:35 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10903 Apr 21, 2009, 12:54 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10926 Apr 21, 2009, 1:08 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10925 Apr 21, 2009, 1:17 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10877 Apr 21, 2009, 1:19 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 11004 Apr 21, 2009, 1:22 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 10894 Apr 21, 2009, 1:23 AM
Thread; hot thread Re: [Westin] Is this possible?
Westin 10861 Apr 21, 2009, 1:26 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 10885 Apr 21, 2009, 1:29 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 10905 Apr 21, 2009, 1:21 AM
Thread; hot thread Re: [Andy] Is this possible?
brewt 10865 Apr 21, 2009, 3:12 AM
Thread; hot thread Re: [brewt] Is this possible?
Westin 10851 Apr 29, 2009, 12:46 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10885 Apr 29, 2009, 1:06 AM
Thread; hot thread Re: [Andy] Is this possible?
brewt 10855 Apr 29, 2009, 1:35 AM
Thread; hot thread Re: [brewt] Is this possible?
Westin 10720 May 4, 2009, 9:57 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10743 May 5, 2009, 12:26 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10720 May 5, 2009, 5:04 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10705 May 5, 2009, 5:14 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10700 May 5, 2009, 5:39 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 10754 May 5, 2009, 5:44 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 10681 May 5, 2009, 6:12 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 10702 May 5, 2009, 6:14 AM
Post; hot thread Re: [Andy] Is this possible?
Wychwood 1492 May 5, 2009, 12:18 PM