[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]
combining rows
Moderator: General Moderators
-
thecodewall
- Forum Commoner
- Posts: 33
- Joined: Sun Dec 26, 2010 8:37 am
Re: combining rows
try to use phpmyadmin web based sql management.