search by month and year

[ctcp]

$results = mysql_query("SELECT * FROM crackz WHERE `option` = 'yes' and `type` = '$type' and name LIKE '%". $query ."%' ORDER BY date DESC LIMIT $page, $limit");

 

my search

how to add search by month and year...

 

[SetToLoki]

$results = mysql_query("SELECT * FROM crackz WHERE `option` = 'yes' and `type` = '$type' and name LIKE '%". $query ."%' ORDER BY date DESC LIMIT $page, $limit");

 

my search

how to add search by month and year...

 

 

Think you need to add a little more info.

[backie]

An example record showing what all the feilds var types are would be helpful.

[ctcp]

<?php
$results = mysql_query("SELECT * FROM crackz WHERE `option` = 'yes' and `type` = '$type' and name LIKE '%". $query ."%' ORDER BY date DESC LIMIT $page, $limit");
while ($data = mysql_fetch_array($results))
{
?>
  <table width="100%" border="0">
    <tr>
      <td width="6%" align="center" nowrap bgcolor="#f8f0e0" scope="col"><a href="?type=<?=$data["type"]?>"><?=$data["type"]?></a></td>
      <td width="12%" align="center" nowrap bgcolor="#f8f0e0" scope="col"><?=$data["date"]?></td>
      <td width="14%" align="left" nowrap bgcolor="#f8f0e0" scope="col">
<?
$URL_parts = @parse_url ($data["links"]);
$DOMAIN = str_ireplace ("www.", "", $URL_parts['host']);
?><?if ( @is_file ("image/rapid/".$DOMAIN.".jpg" ) ){ echo $DOMAIN.""; }else{ echo "Unknown"; }?>
      
      </td>
      <td width="68%" align="left" nowrap bgcolor="#f8f0e0" scope="col"><a href="?section=view&id=<?=$data["id"]?>&type=<?=$type?>" title="<?=$data["name"]?>"><?=$data["name"]?></a></td>
    </tr>
</table>

<?
}
?>