order by fields listing the name

Question

I have a database like this

CREATE TABLE `xyz` (
  `id` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(100) DEFAULT NULL 
)

INSERT INTO `xyz` (`id`, `name`) VALUES
(1, 'train'),
(2, 'bus'),
(3, 'bus'),
(4, 'bus'),
(5, 'train'),
(6, 'train'),
(7, 'train'),
(8, 'car'),
(9, 'car'),
(10, 'car');

I want to sort by name example train is selecting train, all train are fields. how to write this program in zend-framework.

Possible duplicate http://stackoverflow.com/questions/2162709/zend-db-order-by-field-value — Muhammad Zeeshan, Jan 04 '13 at 06:04
Thanks gowri for your helping, but not this exactly i want. i have a site , selected train field shows all the train records in that site — user1947589, Jan 07 '13 at 04:29

score 1 · Answer 1 · answered Jan 04 '13 at 06:02

1

SELECT * FROM `xyz` ORDER BY `name`

answered Jan 04 '13 at 06:02

peterm

91,357
15
148
157

order by fields listing the name

1 Answers1