combining rows

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bkchf123
Forum Newbie
Posts: 11
Joined: Mon Jan 25, 2010 3:01 pm

combining rows

Post by bkchf123 »

[text]CREATE TABLE IF NOT EXISTS `wa_settings` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) collate latin1_bin default NULL,
`type` varchar(50) collate latin1_bin default NULL,
`options` text collate latin1_bin,
`value` varchar(255) collate latin1_bin default NULL,
`grp` varchar(50) collate latin1_bin default NULL,
`subcategory` varchar(50) collate latin1_bin default NULL,
`cond` varchar(255) collate latin1_bin default NULL,
`description` varchar(255) collate latin1_bin default NULL,
`variable` varchar(50) collate latin1_bin default NULL,
`weight` float default NULL,
`spry_args` text collate latin1_bin,
`spry_error` text collate latin1_bin,
`help_text` text collate latin1_bin,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=8 ;[/text]
[text]I have tow columns name value. In the name, there is admin_username and admin_password. In the value is the admin name and password. i want to combine these so that when a user enters a username they will get thier password[/text]
thecodewall
Forum Commoner
Posts: 33
Joined: Sun Dec 26, 2010 8:37 am

Re: combining rows

Post by thecodewall »

try to use phpmyadmin web based sql management.
Post Reply