It seems that whenever I try to make a query with ORDER BY COUNT(field) I always recieve an error from MySQL. Here is the specific query I am trying to use:
SELECT u.username,COUNT(m.entryid) FROM users as u,messages as m WHERE m.userid = u.userid GROUP BY u.userid ORDER BY COUNT(m.entryid)...
Does anyone know of any build-in function or way to compare dates in PHP? For example, on a guestbook script, I would want to only allow a person to sign the guestbook once per hour or so. And it seems like I would have to write a pretty complicated function to verify this. So, I was...
I'm really interested in learning how to use mySQL with Perl, but I can't really find any place to get started. Can anyone recommend any resources or tutorials?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.