hy i have this collums and what i'm trying to do is to
1.make a search form that can show me the total of the values table q1(the sum) for example that i whant to chose a category wich it have same name at collum but different id,
this is my table
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 26 Iun 2014 la 14:49
-- Server version: 5.1.73-cll
-- PHP Version: 5.4.23
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `bolfescu_1`
--
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `articles`
--
CREATE TABLE IF NOT EXISTS `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category` varchar(255) NOT NULL,
`CarrelliCC` int(11) NOT NULL,
`CarrelliCC2` int(11) NOT NULL,
`Carrelli` int(11) NOT NULL,
`Carrelli2` int(11) NOT NULL,
`Ripiani` int(11) NOT NULL,
`Ripiani2` int(11) NOT NULL,
`Prolunghe` int(11) NOT NULL,
`Prolunghe2` int(11) NOT NULL,
`DoppieProlunghe` int(11) NOT NULL,
`DoppieProlunghe2` int(11) NOT NULL,
`q1` int(11) NOT NULL,
`q2` int(11) NOT NULL,
`q3` int(11) NOT NULL,
`q4` int(11) NOT NULL,
`q5` int(11) NOT NULL,
`date` date NOT NULL,
`pv` varchar(255) NOT NULL,
`Carl` int(11) NOT NULL,
`q6` int(11) NOT NULL,
`carl2` int(11) NOT NULL,
PRIMARY KEY (`id`,`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Salvarea datelor din tabel `articles`
--
INSERT INTO `articles` (`id`, `category`, `CarrelliCC`, `CarrelliCC2`, `Carrelli`, `Carrelli2`, `Ripiani`, `Ripiani2`, `Prolunghe`, `Prolunghe2`, `DoppieProlunghe`, `DoppieProlunghe2`, `q1`, `q2`, `q3`, `q4`, `q5`, `date`, `pv`, `Carl`, `q6`, `carl2`) VALUES
(1, 'centro ittico ,12345678993', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, '2014-06-26', '', 1, 0, 1),
(2, 'centro ittico ,12345678993', 100, 50, 100, 50, 100, 50, 100, 50, 100, 50, 50, 50, 50, 50, 50, '2014-06-26', '', 100, 50, 50),
(3, 'acsa,16515', 5, 5, 55, 5, 5, 5, 5, 5, 5, 5, 0, 50, 0, 0, 0, '2014-06-26', '', 5, 0, 5),
(4, 'acsa,16515', 4, 0, 1, 0, 20, 0, 4, 0, 0, 0, 4, 1, 20, 4, 0, '2014-06-26', '', 1, 0, 1),
(5, 'centro ittico ,12345678993', 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 1, 1, 1, 1, 1, '2014-06-26', '', 2, 1, 1);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
for ex
(1, 'centro ittico ,12345678993', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, '2014-06-26', '', 1, 0, 1),
(2, 'centro ittico ,12345678993', 100, 50, 100, 50, 100, 50, 100, 50, 100, 50, 50, 50, 50, 50, 50, '2014-06-26', '', 100, 50, 50),
i whant a sum of q1 of centro ittico....and listed in a table...