Code: Select all
include 'config.php';
echo "<center><h1><u>Support</u></h1></center";
echo "<ul>";
echo "<li><a href='/" . $siteIndex . "/usrmng/main.php?cmd=supportSubmit'>Submit a Ticket</a></li>";
$qTe = "SELECT * FROM tickets ORDER BY date_create";
$gTe = mysql_query($qTe) or die("Database Failure!");
while($row = mysql_fetch_assoc($gTe))
{
$id=$row['id'];
echo '<tr>';
echo '<td class="leftpart">';
echo $row['subject'];
echo '</td>';
echo '<td class="rightpart">';
echo $row['priority'];
echo '</td>';
echo '</tr>';
}
My code keeps dying out at the "or die" part. Without "or die", I get this error:
Code: Select all
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\NewGame\usrmng\functions.php on line 317