Hi all,
I have a site (PHP & MYSQL) that has a basic search engine. The site holds records from different dates. User can select records to review from four date choices. 1qtr 2qtr 3qtr & 4qtr.
Default date is 1qtr until user changes it.
If user changes it when they then search for a key word, returns records found for 1qtr instead of the date they client was under.
Also, user can search for records based on %$keywords%.
Main page uses to following to select date.
$default = "1qtr";
if (isset($_GET['date'])) {
} else {
$date = $default;
}
example: if I was under 4qtr my URL would be
http://www.somesite.com/main.php?submit=Search&date=4qtr
how do I get my search grab the date off of the url . Here is my search.
if is populated from a form
if ($keyword != "" && isset($where))
{
// switch loop
switch ($where)
{
// description search
case 1:
$query .= " AND (files.acct LIKE '%$keyword%')";
$query1 .= " AND (files.acct LIKE '%$keyword%')";
break;
// filename search
case 2:
$query .= " AND (files.lname LIKE '%$keyword%')";
$query1 .= " AND (files.lname LIKE '%$keyword%')";
break;
/ Rep ID search
case 3:
$query .= " AND files.rep_id LIKE '%$keyword%'";
$query1 .= " AND (files.rep_id LIKE '%$keyword%' )";
break;
// search all!
case 4:
$query .= " AND (files.acct LIKE '%$keyword%' OR files.lname LIK
E '%$keyword%' or files.rep_id LIKE '%$keyword%')";
$query1 .= " AND (files.acct LIKE '%$keyword%' OR files.lname LI
KE '%$keyword%' or files.rep_id LIKE '%$keyword%')";
break;
}
}
?>
Thanks in advance
