[SOLVED] MySQL WHERE and BETWEEN problem!

[budimir]

Hey guys,

 

This is a new thing for me and I can't get to work. Can someone help?

 

This is my query and is not working right now.

 

$upit = "SELECT * FROM obilasci WHERE upisao = '$upisao' AND datum BETWEEN '$_GET[timestamp]' AND '$_GET[timestamp1]'";

 

When I take pute my upisao = '$upisao' clause, everything is OK, but I need to have that one too.

 

Help, please...

[Maq]

Shouldn't the GETS have single quotes around the names, like this:

 

'$_GET['timestamp']' AND '$_GET['timestamp1']'

 

[budimir]

It works without the quotes.

 

But anyway I figured it out. Below is the solution.

 

$upit = "SELECT *, COUNT(naziv) AS broj2 FROM obilasci JOIN opcenito ON opcenito.id = obilasci.id WHERE datum BETWEEN '$_GET[timestamp]' AND '$_GET[timestamp1]' GROUP BY naziv";

 

Cheers guys