[SOLVED] Another mind numbing question on query dates BETWEEN

[spillage]

Sorry

 

After spending hours looking I think I need to post this question.

My code is:

$result = mysql_query("SELECT * FROM email WHERE printer LIKE '%$printer%' WHERE time BETWEEN '$date' '$todate'");

if ($cust=='all')
    {
    while($row = mysql_fetch_array($result))
    {
echo $row['printer']."  | ".$row['cust']," | ".$row['friend'];
    echo "</br>";
    }
    }
else if ($cust=='cust')
    {
while($row = mysql_fetch_array($result))

   {echo $row['printer']."  | ".$row['cust']," | ";
    echo "</br>";
}
    }
else if ($cust=='friend')
    {
	while($row = mysql_fetch_array($result))
    {
echo $row['printer']."  | ".$row['friend']," | ";
    echo "</br>";
    }
    }

 

This will not run at all. If I print out the values of $data and $todate they both show yy-mm-dd.

If I remove the time query then everything runs fine.

 

Really hit a brickwall. Do not that I have been cutting and adding to the code in the query so whats shown may have

a couple of typos in.

 

Cheers,

 

Spill.

[fenway]

You mean:

 

$result = mysql_query("SELECT * FROM email WHERE printer LIKE '%$printer%' AND time BETWEEN '$date' AND '$todate'");

 

The "AND" was missing for BETWEEN, and you had two where clauses.

[spillage]

cheers for the reply fenway  I am sure I had tried this and got an error within the if code.

 

BUT as I am find in this world of code its all now working.

 

So thanks again fenway and Im off to have a couple beers.

 

Spill