pneudralics Posted April 8, 2009 Share Posted April 8, 2009 Select count is returning more than the category specified. I want to limit the count to $categoryvariable, but it seems like I'm still getting more than the specified count. $categoryvariable = $_GET['category']; $sql = "SELECT COUNT(*) FROM category WHERE category = \"$categoryvariable\""; Quote Link to comment https://forums.phpfreaks.com/topic/153216-is-this-select-count-correct/ Share on other sites More sharing options...
Maq Posted April 8, 2009 Share Posted April 8, 2009 No. $sql = "SELECT COUNT(*) FROM category WHERE category = '$categoryvariable'"; Quote Link to comment https://forums.phpfreaks.com/topic/153216-is-this-select-count-correct/#findComment-804850 Share on other sites More sharing options...
pneudralics Posted April 8, 2009 Author Share Posted April 8, 2009 Thanks. Why is it that you need single quotes instead of double with a variable in it? Wouldn't single read it as $categoryvariable instead of whatever the $categoryvariable actually is? Quote Link to comment https://forums.phpfreaks.com/topic/153216-is-this-select-count-correct/#findComment-804860 Share on other sites More sharing options...
Maq Posted April 8, 2009 Share Posted April 8, 2009 Thanks. Why is it that you need single quotes instead of double with a variable in it? Wouldn't single read it as $categoryvariable instead of whatever the $categoryvariable actually is? That's just the way it is. If it's an integer you do not need single quotes around values. No, because the actual string is in double quotes so it's interpolated into the entire string. Does that make sense? Quote Link to comment https://forums.phpfreaks.com/topic/153216-is-this-select-count-correct/#findComment-804861 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.