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?
I don't know much about XP or either of those servers. But I am on 98 and I use Xitami web server to test my scripts. I'd go with the server which takes the least time to set up and configure, because you don't need it for much more that script testing right?
I've noticed that sometimes IP address are not recorded as well. I don't think that it is an error in your script. It just may be that your server couldn't get the IP of the user.
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.