I have a database table(eyfstb) containing two fields,
datetable = ",2019-11-04,2019-11-06,2019-11-08"
documenttable = ",first,second,third"
I am trying to use two input fields to get a range of data from the database.
I want the result to be
$datefiles = ",2019-11-04,2019-11-06";
$documentfiles = ",first,second";
What I have tried:
I have a database table(eyfstb) containing two fields,
datetable = ",2019-11-04,2019-11-06,2019-11-08"
documenttable = ",first,second,third"
I am trying to use two input fields to get a range of data from the database.
<form method="POST" action="" id="my_form">
<small>Start</small>
<input type="date" name="datfrm">
<input type="date" name="datto">
<small>End Date</small>
<input type="submit" name="subdr" value="Display Record"></center>
</form>
i want to get the record "first,second" and the date "2019-11-04,2019-11-06" if the date ranges are 2019-10-01 to 2019-11-07
$products = $db->query("SELECT datetable,documenttable FROM eyfstb WHERE specialnum='$rollnum'");
while($row = $products->fetch_assoc()){
$datefiles = $row["datetable"]; $documentfiles = $row["documenttable"];
I want the result to be
$datefiles = ",2019-11-04,2019-11-06";
$documentfiles = ",first,second";