php not executing
Posted: Tue Feb 06, 2007 6:46 pm
my php code wont execute or even show any of the html.
it works on the rest of the site http://www.sundaybrew.com
it wont show any on http://www.sundaybrew.com/linklist.php
any ideas/
it works on the rest of the site http://www.sundaybrew.com
it wont show any on http://www.sundaybrew.com/linklist.php
any ideas/
Code: Select all
<table width="100%" border="0">
<tr>
<td><div align="center">Site</div></td>
<td><div align="center">Hits In</div></td>
<td><div align="center">Hits Out</div></td>
</tr>
<?php
include("dbsetts.php")
$conn=mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname) or die ("Unable to connect to MySQL");
$result = mysql_query( "SELECT * FROM sites ORDER BY hits_in DESC" ) or die("SELECT Error: ".mysql_error());
while($row=mysql_fetch_array($result) )
{
print '
<tr>
<td><div align="center"><a href="' . $row['site_url'] . '">' . $row['site_title'] . '</a></div></td>
<td><div align="center">' . $row['hits_in'] . '</div></td>
<td><div align="center">' . $row['hits_out'] . '</div></td>
</tr>';
}
?>
</table>