budimir Posted August 22, 2008 Share Posted August 22, 2008 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... Link to comment https://forums.phpfreaks.com/topic/120847-solved-mysql-where-and-between-problem/ Share on other sites More sharing options...
Maq Posted August 22, 2008 Share Posted August 22, 2008 Shouldn't the GETS have single quotes around the names, like this: '$_GET['timestamp']' AND '$_GET['timestamp1']' Link to comment https://forums.phpfreaks.com/topic/120847-solved-mysql-where-and-between-problem/#findComment-623024 Share on other sites More sharing options...
budimir Posted August 22, 2008 Author Share Posted August 22, 2008 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 Link to comment https://forums.phpfreaks.com/topic/120847-solved-mysql-where-and-between-problem/#findComment-623091 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.