in reply to Managing Inventory Sections with Perl and SQL

looks like you need to read up on relational databases to get the full benefit, BUT here goes: do store the section name in a separate field, indexing on that field if necessary....later on when you do the sql query you do SELECT field_name1, field_name2, etc FROM table_name WHERE section_field = $your_desired_value
on the issue of prices: usually store RRP and SOLD prices, as well as $ taxed and even conversion rate and currency name if used to sell to overseas customers.
  • Comment on Re: Managing Inventory Sections with Perl and SQL