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?
le="color: #000000"><?php <?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); ?> <p> </p> <p> </p> <table width="323" height="151" border="0" align="left" cellpadding="0" cellspacing="0"> <tr bgcolor="#CCCCCC"> <td width="153" height="151"> <p align="left"><b><font color="#525452" size="1" face="Verdana">Start Date: <?= $rs->Fields['Data_01']->Value ?> </font></b></td> <td width="260"> <p align="left"><b><font color="#525452" size="1" face="Verdana">Impact Area: <?= $rs->Fields['Data_02']->Value ?> </font></b></td> <td width="84"> <p align="left"><b><font color="#525452" size="1" face="Verdana">Impact %: <?= $rs->Fields['Data_03']->Value ?> </font></b></td> </tr> </table>