5 Replies Latest reply on Dec 23, 2008 9:50 PM by ty554r

    Mysql Select Problem

      Good day all.

      Im having problems with selecting information from a mysql database.

      This is what i want to do.

      I have a table with a bunch of products and prices in them.

      This is the query i use to access the info which works perfectly

      SELECT CONCAT(groupno,"-",subcode) AS 'Key', CONCAT(groupno, " - ",subcode," - ",headertext," - ",description," -R",price) as 'VALUE'
      FROM subgroups