in the following hack...
web_store_mysql_db_lib.pl is used to implement a MySQL
database in the eXtropia.com Webstore.
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.
This routine submits a SQL query to
the MySQL database and returns the results in an
array for each row returned.
This routine builds the WHERE query expression based on the search criteria.
Get the file here!