[ic] How to send input from a form page to a SQL query page???

[interchange-users@interchange.redhat.com (Ed LaFrance)]

At 09:36 PM 01/27/2002 +1100, you wrote:
>I am trying to create a search form that will produce a list from a large
>MySQL alternate products table.
>
>
>In my search page:
>
>PLEASE ENTER SEARCH KEY WORD:
>
><form action="[area results-sqltest]" method=post>
>         <input type=hidden name=mv_session_id value="[data session id]">
>
>                 <INPUT NAME=keyword type=text size=8>
>
><input type="image" alt="Search Go" width="45" border="0"
>src="__THEME_IMG_DIR__go.gif">
>               </td>
>           </tr>
>         </table>
>       </form>
>
>
>--How do I get the keyword entered above into my SQL query result page
>below?
>
>
>The results-sqltest.html page:
>
>
>    [query sql="select * from sqltestdatabase
>                where prod_group = 'Toys'
>and category = 'Beanie Baby'
>and description = ??????????  <----WHAT DO I NEED TO PUT HERE FOR IT TO
>WORK?????----

I would try '[value keyword]'

- Ed L.


>          type=list
>        ml=1000]
>
>       [list]
>Product: <b>[sql-data sqltestdatabase description]</b> <br><i>Category:
>[sql-data sqltestdatabase category]</i>Our Price: $[sql-data sqltestdatabase
>price]
>       [/list]
>
>    [/query]
>
>
>
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================