Hi-
I need to place an SQL command in nph-build.cgi. If I were placing it in the SQL Monitor the command that works is:
UPDATE lsql_Links
SET Level_Sort = '1'
WHERE Level = 'Featured'
To place it in nph-build.cgi I think it would go something like:
$DB->table('Links')->update ( { Level_Sort => \'1' WHERE Level = 'Featured'});
But this doesn't seem to be doing the trick. I think it's probably something off with the text in red. Does anyone know the proper syntax to get this to work?
--Frank
I need to place an SQL command in nph-build.cgi. If I were placing it in the SQL Monitor the command that works is:
UPDATE lsql_Links
SET Level_Sort = '1'
WHERE Level = 'Featured'
To place it in nph-build.cgi I think it would go something like:
$DB->table('Links')->update ( { Level_Sort => \'1' WHERE Level = 'Featured'});
But this doesn't seem to be doing the trick. I think it's probably something off with the text in red. Does anyone know the proper syntax to get this to work?
--Frank