I'll brb I have to go to the store could you post your mysql table so I can test the code to make sure what I give you works. I spotted an error really fast what your using a variable in a query you need to add it like so

$Q = "SELECT * FROM clt_transact WHERE cloth_type = '".$cloth_type."'";

its single quote, double quote, period, variable, period, double quote, single quote or ' " . $myVar . " ' (minus the spaces).

Last edited by pein87; 4Jan2011 at 06:24..