sent
in the following hack...
web_store_mysql_db_lib.pl is used to implement a MySQL
database in the eXtropia.com Webstore.
Subroutines:
check_db_with_product_id
The web store takes this procedure and double checks that the order
within the cart matches the product description
in the MySQL database. This is a security check.
submit_query
This routine submits a SQL query to
the MySQL database and returns the results in an
array for each row returned.
mysql_build_criteria
This routine builds the WHERE query expression based on the search criteria.
Get the file here!