i have this code to search the a database field between two dates:
$result = mysql_query ("SELECT * FROM mybrothers
WHERE PROFTDAT1 BETWEEN '$begtemp' AND '$endtemp'
AND SDATFIN1 = ' '
AND MORTDAT1 = ' '
ORDER BY PROFTDAT1 ASC, CNOMEN
",$conn);
$resultall = mysql_query ("SELECT * FROM friarsofmconv");
}
echo ("<p>");
echo ("<p>");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
?>
this searches only one fields from a table on the database. however i like to have on my search form the possibility to search other fields on the table, something like:
$result = mysql_query ("SELECT * FROM friarsofmconv
WHERE PROFTDAT1 BETWEEN '$begtemp' AND '$endtemp'
WHERE NATDAT1 BETWEEN '$begbday' AND '$endbday'
AND SDATFIN1 = ' '
AND MORTDAT1 = ' '
ORDER BY PROFTDAT1 ASC, CNOMEN
",$conn);
but this gives me no result or errors! can anyone help please,
SELECT * FROM friarsofmconv
WHERE (PROFTDAT1 BETWEEN '$begtemp' AND '$endtemp')
AND (NATDAT1 BETWEEN '$begbday' AND '$endbday')
AND SDATFIN1 = ' '
AND MORTDAT1 = ' '
ORDER BY PROFTDAT1 ASC, CNOMEN