Welcome Guest, Not a member yet? Register   Sign In
Best way to update -> Table --> name + value field
#1

[eluser]internut[/eluser]
Suggestions welcome. I'm not sure how to go about it just yet:

--
-- Table structure for table `settings`
--

Structure:

Code:
CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(255) NOT NULL default '',
  `setting` mediumtext NOT NULL,
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Is there a way I can take an array and update fields in this "settings" table?

Or do i need to make a single query with a WHERE name='setting_name'

?


Messages In This Thread
Best way to update -> Table --> name + value field - by El Forum - 07-16-2008, 11:46 PM
Best way to update -> Table --> name + value field - by El Forum - 07-16-2008, 11:51 PM



Theme © iAndrew 2016 - Forum software by © MyBB