View Single Post
Old 06-14-2005, 12:16 AM  
rickholio
Confirmed User
 
Industry Role:
Join Date: Jan 2004
Location: Nor'easterland
Posts: 1,914
You have an extra ( after values. Multi row inserts have brackets around each row, not around all rows.

Also, every one of those $config[blogname]'s need to be encapsulated in additional quotes unless $config[blogname] is guaranteed to be a number of some variety.

HTH. HAND.

BTW - you *can* use subscripted arrays within quotes in PHP, thusly:

$result = mysql_query("Insert into bBadult_config
(id, name, value)
VALUES
(1, 'EMAIL', 'change@me'),
(2, 'BLOGNAME', '$config[blogname]'),
(3, 'TEMPLATE', 'default'),
(4, 'DB_TEMPLATES', 'false'),
(5, 'DEFAULT_MODIFIER', 'simple'),
(6, 'DEFAULT_STATUS', 'live'),
(7, 'PING','false'),
(8, 'COMMENT_MODERATION','none'),
(9, 'NOTIFY','false'),
(12, 'META_DESCRIPTION', 'Some words about this blog'),
(13, 'META_KEYWORDS','work,life,play,web design'),
(15, 'EMAIL','[email protected]'),
(10, 'BLOG_DESCRIPTION', '$config[blogdescription]'),
(14, 'LAST_MODIFIED', UNIX_TIMESTAMP())");
__________________
~

Last edited by rickholio; 06-14-2005 at 12:19 AM..
rickholio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote