I always get this error when i run my code
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''leave'' at line 1
Here is my coding part
<?php
$result = mysql_query("select * from 'leave'");
if ($result == FALSE)
{
die(mysql_error());
}
while($row = mysql_fetch_assoc($result))
{
?>
<tr>
<td><a href = "app_status.php? id = <?php echo $row["Leave_ID"];?>" target = "_blank"></a>Leave ID</td>
<td><?php echo $row["Emp_ID"];?></td>
<td><?php echo $row["Date_Apply"];?></td>
<td><?php echo $row["Leave_Type"];?></td>
<td><?php echo $row["Leave_Start"];?></td>
<td><?php echo $row["Leave_End"];?></td>
<td><?php echo $row["Status"];?></td>
</tr>
<?php
}
?>