Is it possible to make a script in Optigold to execute different sql commands based upon which value is in a field in OptiGold? Stephen
To clarify my previous question - the value in the field in OptiGold would not be a value to be entered directly into the SQL db but would only be used to determine which predefined sql commands and values would be executed.
No, there is not any if/then/else logic available within the SQL statement (other than the normal IF() statement you can use within the SQL statement itself.
What I have found is to use a standard Http trigger to send a get url to a custom php scrip on my server with the optigold fields passed through the url, this way I can manipulate any data I want through php.. It also bypases the cost of the Nettools plugin with enhanced functionality.