I have this, but not sure how to get current date to show only. I also know that this needs to be fixed so it does not get SQL injection. Anyone have an idea what I can do to show the current date only of the records.
$sql = "SELECT id, lanId, name, department, manager, request, request_description, request_comments, status, comments, compUser, compDt FROM requests WHERE status='Completed' AND compUser='xgrh'CURDATE()";
$results = mysql_query($sql) or die(mysql_error());
This is on my admin page
<tr>
<td style="width: 125px"><a href="xgrhCompleted.php" target="Frame">xgrh</a></td>
<td style="width: 125px" align="center"><a href="xgrhCompleted.php" target="Frame"><?php $result = mysql_query("SELECT COUNT(*) FROM requests WHERE status='Completed' AND compUser='xgrh'");
while($row=mysql_fetch_array($result))
{
echo $row['COUNT(*)'];
} ?></a></td>
</tr>
</div>