problum wth sql and script php ( get data from cureent date in php)

[umer007]

<link rel="stylesheet" type="text/css" href="tcal.css" />
 <script type="text/javascript" src="tcal.js"></script>
 <form action="11.php" method="get">
Date : <input type="text" name="date" class="tcal" value="" />
<input type="submit" value="Search">
</form>
<table id="resultTable" data-responsive="table" style="text-align: left; width: 400px;" border="1" cellspacing="0" cellpadding="4">
<thead>
    <tr>
    <th> Name </th>
    <th> Gender </th>
</tr>
</thead>
<tbody>
<?php
include('connect.php');
if (isset($_GET["date"])) { $date = $_GET["date"]; } else { $date=0; }; 
$result = $db->prepare("SELECT * FROM birthday WHERE date  :a");
$result->bindParam(':a', $date);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
<tr class="record">
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['gender']; ?></td>
</tr>
<?php
}
?>
</tbody>
</table>

when i select the any date then i get all dates data values from mysql database. so i want to set this example if i select any one date then i get data of selected date only not all. for understanding my concept you can visit here http://joomusic.info/joosilver.php here you can see the box where i select the date and i get the data. i want same this thing.

[Dormilich]

you’re missing an equal sign in your SQL.