mikefrederick

I don't think the site has had 30 visitors at once thus far, and each file has: require 'connectionfile.php' at the top and does not open any other connections except for in that file. Weird right?

I just launched a new site on bluehost and I have gotten the error: mysql_connect()...Too many connections in... Bluehost says the max connections is 30 and I don't have access to change that. All of my files close database connections at the end of the file. That being said, I don't have many users yet and this problem worries me. Any insight/suggestions?

I have two fields, wins and losses, in my table. I want to order the results by wins - losses. Is there anyway to do this from within the mysql_query? Calculating the difference between the two fields would be easy afterwards with php, but since I want to order the results by the difference I am looking to do something like "select whatever as"...

Yeah I know, but is it even possible to check for new emails via cron jobs?

I don't even know how I would setup a cron job to check for new emails. And I feel like there has to be another way. Basically, I have a message board on a website. When someone is sent a message, it is forwarded to their email address. I want people to be able to respond to emails directly from their email address. In other words: -they send a reply email (to something like messageboard@mysite.com) -the contents of that email are stored in the database so that the message board is updated -the original message sender's email address is grabbed from the database and the email is forwarded to that email address

Hopefully someone can help me here. I am wondering how to go about updating some tables in my databases when my server receives an email. For example, if I wanted to submit the body of the email into a database, how would I go about doing this? Directions, a link to a guide, or any help is appreciated. Thanks.

Hopefully someone can help me here. I am wondering how to go about updating some tables in my databases when my server receives an email. For example, if I wanted to submit the body of the email into a database, how would I go about doing this? Directions, a link to a guide, or any help is appreciated. Thanks.

I just grabbed a time from my database that was put in there a couple days ago using strtotime(date('m/d/Y')); When I echo date('m/d/Y',$grabbed_date); I get today's date. BUT, when I echo strtotime(date('m/d/Y')); it does not equal the grabbed date. Why is this?

yeah i know, but in FF3 it actually was doing that. this was right after it came out, i am going to test it again.

use a cron job

I am building a site where users need to be able to reset there passwords. The passwords are stored as md5, and when they click 'reset password' an action is run to grab a random string and set that as the password. The problem is that when they click reload on the page that the script forwards to, the script is run through again and so the password is changed again. Right now, I am taking the random string and using base64_encode and putting it in the URL. I wish I could just grab the password from the database, but that's not possible with md5. What's a good way to handle this?

making a site w/ users. upon signup I want to check if a username is taken and if it is I want to add a 1 to the end of the username, check again, if that one is taken add a 2, and so on until the username is not taken. whats a good approach?

if you're not careful hackers can alter the email itself as well, including the headers. mostly i was wondering what the advantage of image verification vs. a hidden field is? there must be one because everyone uses image verification, but a hidden field is more pleasant for the user.

what is the best way to prevent spamming from your html forms? what about adding a hidden field and not sending the email if the field is filled?

if(hour%2==1) { update }