selecting records between dates

[18241]

please help somebody please!?

i need some code that will select all the records in between two dates based on someone entering in these two dates. problem is i have no idea how to code it as i dont fully understand the coding behind it. here is the code that i already have could someone have a look and see what im missing please 🙂 .

<form name="getdates" method="post" action="">
From:
<input name="date1" type="date">
To:
<input type="date" name="date2">
<input type= "submit" name="datesbetween" value="Get Dates">
</form>
<?php
$date1 = date(d,m,Y);
$date2 = date(d,m,Y);

if ($called){

		return false
		else
			return true
			$date = mysql_query ("SELECT * FROM calls WHERE calls.called ");
		}

?>

thanks in advance

18241

[severndigital]

there are several things that you will have to use to make this work

1. a loop to get each record out of the database
2. an action script for the form.

once you design your form you'll have to point it towards another script, or itself to process the form.

<form name="getdates" method="post" action="do_getdates.php">

you would then house your database script in that file.

which might look something like this.

//connect to the database
include 'connect.php';

//get the dates from the form

$date1 = $_POST['date1']; //these two are extracting the information from the form
$date2 = $_POST{'date2'];

//in your code you used $date1 = date(d,m,y) this was pulling the date from the server not the form.

//this next part is tricky because we have to format the date correctly for extraction from
//the database. I am assuming the data is being collected like this

//$date1 = 06/10/2006
//and that your database is housing the information like this
// 2006-10-06

//unless you collect the date in the form the exact same way you have it housed in database
//you will have to pull it apart and piece it back together again

$date1 = explode("/",$date1); //this will split the variable inside the explode into an array using a / as the break point.

//this is a numbered array and starts with 0, so your date would be come day=0 month =1 year = 2

$date2 = explode("/",$date2);

//now we have to put them back together the right way for searching.

$date1 = "$date1['2']-$date1['1']-$date1['0']"; //this will now format the date in 2006-10-06 format
$date2 = "$date2['2']-$date2['1']-$date2['0']";

//now you'll have to search the database for entries that are => date1 and <= date2

$sql = "SELECT * FROM calls WHERE date => '$date1' AND <='$date2'";

$pull_dates = mysql_query($sql);

//once you are pulling the correct information you will have to loop it to get all the 
//dates from the database.

while($r = mysql_fetch_array($pull_dates)){

//now you can extract and echo the information from the database. 
//we will assume your database names 

$call_title = $r['fieldname']; //replace fieldname with the name from your database
$call_desc= $r['fieldname2'];

then echo them and any other information you might want.

echo $call_title;
echo '<BR>';
echo $call_description

}//close the loop

that should do it.

there maybe a bug or two in the script as i didn't test it thoughly, but the theory is sound, i use it all the time.

i hope i did a good job explaining it.

anyone else who reads this feel free to make corrections / revisions.

chris

[18241]

thank you very much for this. it was very well explained, as im a moron at this most times 😛,

18241.