Hi,

First I need to know how to call my own custom templates? I've created just a basic body template (goes in between header and footer) and named it simply pricecheck.html and one named priceresult.html

How do I call that with the page.cgi file?

The next part is the custom part that i would need assistance with as I don't even know where to start.

I have a database of prices in a table named price

I want to place a simple form on the pricecheck.html template that allows a user to enter in up to 10 item names.

When submitted this would check the names against the name column in the price table, and bring back the results of that row in the price table and show them it on the priceresult.html template.

Now I know this isn't strictly Links SQL related, however Im thinking that it's probably already got the guts in place and only needs maybe some template globals to accomplish all this. But for where to start, do it, or end it, Im at a loss as I don't have that knowledge.

All help appreciated.

Structure of the price table:
name
price
stdev
average
high
low
change
rawn

So when someone enters the name of [CARD A] it should look into the price table and find the row with [CARD A] listed as the name and then gather the rest of the fields in the price table and bring them back on the priceresult.html template for me.

Thanks