I'm currently learning how to build a site in PHP mysql. However, I seem to fail to understand
COUNT() as count and wouldn't mind some further explanation.
I get the principles of COUNT, 0 || 1, and how it returns all the values that pertain to that query. But, don't see how COUNT as count works.
Anyhow, this is how the code I'm writing goes - so we have a working example - and where I first became perplexed.
SELECT COUNT(`id`) as `count`, `id` FROM `user` WHERE `email`='$email' AND `password`='".md5$password."'";
If anyone can explain be a great help!