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... Quote 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']' Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.