simple question.. why isnt this working?

[jbrill]

Im trying to sort some queries form the database,

heres the code:

[code
<?
//already connected to database

//get these variables from the URL
$employee = $_GET['employee'];
$fromdate = $_GET['fromdate'];
$todate = $_GET['todate'];


$allresultssql = "SELECT * FROM workhours WHERE name='".$employee."' AND BETWEEN date='".$fromdate."' AND  date='".$todate."'";
$allresults = mysql_query($allresultssql);
$results = mysql_fetch_array($allresults);
?>

 

why will this not work?

[AndyB]

Why won't it work? Because your query syntax is wrong!

 

Example: http://www.webdevelopersnotes.com/tutorials/sql/tutorial_mysql_in_and_between.php3

[redarrow]

try that

 

allresultssql = "SELECT * FROM workhours WHERE name='".$employee."' AND date='".$fromdate."'  BETWEEN  date='".$todate."'";

[Barand]

That's as bad as the original.

 

$allresultssql = "SELECT * FROM workhours 
               WHERE name = '$employee' 
               AND date BETWEEN '$fromdate' AND  '$todate' ";