php search issue

Hi.....

below the php code for search name and date

<?php
if($block == false){
include "header.php";

$nam = $_POST['nam'];
$datt = $_POST['datt'];
?>
<form method = POST action = "search.php">
Name <input type=text name=nam value = "%%">
Date <input type=text name=datt value = "<?php echo($datt);?>">
<input type=submit name=submit value="Search">
</form>
<?php
$sub = $_POST['submit'];
if($sub == ""){
if($nam!="" && $dat!=""){
$t = "select * from timesheet where name like 'nam' && dat like '$datt'";
}
else if($nam!="" || $datt!=""){
$t = "select * from timesheet where name like 'nam' || dat like '$datt'";
}
else{
$t = "select * from timesheet order by id desc";
}
$res= mysql_query($t,$link);

echo "<table align=center cellpadding=4px cellspacing=4px>
<tr align=center><td>ID</td><td>Name</td><td>Date</td><td>Total working Hours</td></tr>";
$a=1;
while($line=mysql_fetch_row($res))
{
echo "<tr align='center'><td>$a</td><td>$line[1]</td><td>$line[2]</td><td>$line[3]</td></tr>";
$a++;
}
echo "</table><br><br>";
}

else{
echo "Please enter the search details";
}
}
?>
Click to expand...

this code cannot display the search details...

Pls help me

Log in or Sign up

php search issue

subha rr Guest

iDemonix Peon

Log in or Sign up

php search issue

subha rr Guest

iDemonix Peon

Useful Searches