I am trying to display results from a MySQL query to the JIRA Database using an HTML macro. The script I put in looked like it should work, however, it doesn't show anything. The page is completely blank. What am i doing wrong?
<script>
<?php
$con=mysqli_connect("example.com","user","pass","database");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM cwd_user");
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['first_name'] . "</td>";
echo "<td>" . $row['last_name'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
</script>
