1
The following code was pasted into a custom block and PHP Script was selected from the dropdown no results displayed,
If I choose the HTML option the preview window actually displays results, but when submitted I get the actual code and not the desired result:
Why do you think that is?
PHP
$db="MySQL2000Server";
$conn= new COM('ADODB.Connection');
$conn->Open("driver={SQL Server};SERVER=MySQL2000Server;DATABASE=MyDatabaseName;UID=MyUserID;PWD=MyPassword;");
$MySQL = "SELECT * from tblData";
$rs = $conn->Execute($MySQL);
?>
Start Date: = $rs->Fields['Data_01']->Value ?> |
Impact Area: = $rs->Fields['Data_02']->Value ?> |
Impact %: = $rs->Fields['Data_03']->Value ?> |