List:General Discussion« Previous MessageNext Message »
From:spacemarc Date:May 2 2007 6:29pm
Subject:Re: View select results
View as plain text  
2007/5/2, Peter Brawley <peter.brawley@stripped>:
> Works for me. Please post a CREATE TABLE stmt & enough INSERTs to
> demonstrate the problem.

This is the dump (MySQL: 5.0.38): the table is not final version, just
to test the query.

CREATE TABLE `products` (
 `area` varchar(25) NOT NULL,
 `text` varchar(25) NOT NULL,
 `amount` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `products` (`area`, `text`, `amount`) VALUES
('area1', 'some text', 12),
('area1', 'other text here', 13),
('area3', 'example...', 22),
('area2', 'things', 123),
('area1', 'bla bla...', 24),
('area2', 'others again', 231),
('area1', 'english language..', 44),
('area1', 'server database', 53),
('area3', 'php language...', 22),
('area2', 'linux box', 951),
('area1', 'developer tools', 4),
('area2', 'others words', 1);



-- 
http://www.spacemarc.it
Thread
View select resultsspacemarc2 May
  • Re: View select resultsBaron Schwartz2 May
  • Re: View select resultsPeter Brawley2 May
Re: View select resultsspacemarc2 May
Re: View select resultsPeter Brawley2 May
  • Re: View select resultsspacemarc2 May
    • Re: View select resultsPeter Brawley2 May