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

interchange-users@interchange.redhat.com interchange-users@interchange.redhat.com
Sun Jan 27 05:36:00 2002


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?????----
         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]