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 13552 Apr 19, 2009, 10:16 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13379 Apr 20, 2009, 12:35 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13356 Apr 20, 2009, 10:47 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13361 Apr 21, 2009, 12:35 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13370 Apr 21, 2009, 12:54 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13397 Apr 21, 2009, 1:08 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13388 Apr 21, 2009, 1:17 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13348 Apr 21, 2009, 1:19 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13531 Apr 21, 2009, 1:22 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 13363 Apr 21, 2009, 1:23 AM
Thread; hot thread Re: [Westin] Is this possible?
Westin 13340 Apr 21, 2009, 1:26 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 13345 Apr 21, 2009, 1:29 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 13370 Apr 21, 2009, 1:21 AM
Thread; hot thread Re: [Andy] Is this possible?
brewt 13338 Apr 21, 2009, 3:12 AM
Thread; hot thread Re: [brewt] Is this possible?
Westin 13333 Apr 29, 2009, 12:46 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13356 Apr 29, 2009, 1:06 AM
Thread; hot thread Re: [Andy] Is this possible?
brewt 13326 Apr 29, 2009, 1:35 AM
Thread; hot thread Re: [brewt] Is this possible?
Westin 13192 May 4, 2009, 9:57 PM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13211 May 5, 2009, 12:26 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13191 May 5, 2009, 5:04 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13174 May 5, 2009, 5:14 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13166 May 5, 2009, 5:39 AM
Thread; hot thread Re: [Westin] Is this possible?
Andy 13224 May 5, 2009, 5:44 AM
Thread; hot thread Re: [Andy] Is this possible?
Westin 13151 May 5, 2009, 6:12 AM
Post; hot thread Re: [Westin] Is this possible?
Andy 13165 May 5, 2009, 6:14 AM
Post; hot thread Re: [Andy] Is this possible?
Wychwood 1804 May 5, 2009, 12:18 PM