[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] How to send input from a form page to a SQL query page???
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]