i am tying to query from a db and cant get the time section to come back with the correct result PLEASE HELP!!!!!!
<html>
<head>
<title>Loggin DB</title>
</head>
<body>
<h1 align=left>Please enter search feilds:</h1>
<body bgcolor="#82CAFA">
<form method="get" action="loggin1.php">
Page:
<select name="Page">
<option value="approve.php" >Approve</option>
<option value="custquery" >CustQuery</option>
<option value="slpnlogin">SlpnLogin</option>
</select>
User Code:
<select name="UserCode">
<option >T3</option>
<option >J9</option>
<option>BL</option>
<option >SC</option>
<option >MN</option>
<option >CA</option>
<option>MW</option>
<option >TJ</option>
<option >E2</option>
<option >D6</option>
<option >SS</option>
<option >R9</option>
<option >GL</option>
<option >MP</option>
<option >RW</option>
</select>
Date:
<input type="text" name="time">
<p><input name="submitted" type="submit" value="send"/></p></form>
<?php
$db = $_SERVER['DOCUMENT_ROOT']."/../data/log.db"; //connect to sql
$handle = sqlite_open($db);
$query = "SELECT * FROM log where id <= 85076 ";
if(isset($_GET['submitted']) && $_GET["submitted"] == "send")// line check
{
if ($_GET["Page"] !="")
{
$query.=" and page=\"" .$_GET["Page"]."\"";
}
if ($_GET["UserCode"] !="")
{
$query.=" and userCode=\"" .$_GET["UserCode"]."\"";
}
if(isset($_GET["time"]))
{
$time = strtotime($_GET["time"]);
$query.=" and time <='" .$time."'";
}
}
echo $query;// show the result of the search
$result = sqlite_query($handle, $query);
$row = sqlite_fetch_array( $result );
echo "<style type='text/css'>
table {
border-width: 1px;
border-spacing:0px ;
border-style: double;
border-color: black;
border-collapse: separate;
background-color: #82CAFA;
}
table th {
border-width: 1px;
padding: 0px;
border-style: solid;
border-color: black;
background-color: #82CAFA;
}
table td {
border-width: 1px;
padding: 3px;
border-style: solid;
border-color: black;
background-color: #82CAFA;
}
</style>
<table class='db'; cellspacing=\"0px\">";
while($row = sqlite_fetch_array($result)){
echo " <tr>\n";
echo " <td> $row[id]</td><td> $row[page]</td> <td> $row[desc] </td><td> $row[userCode] </td><td> $row[codeType] </td><td>". date( "Y-m-d", $row['time'])."</td><td> $row[ipaddr]</td>\n";
echo " </tr>\n";
}
echo "</table>";
?>
</html>