cahrehn

I gave it a quick look in emacs and the automatic paren matching says that you need two more closing parens at the end. one closes: if(isset($_POST['addstamp'])){ and the other closes: if(isset($_POST['sent'])){ What are you using as an editor? If it's something without paren matching, Notepad++ and Jedit are two good Windows options and I like emacs on linux. I'd like to start using Eclipse, but that's going to take time to learn.

@Mark: Thanks, I'll look into APC and ssl encryption to see if either will do what I want. @PFMaBiSmAd: The database will be on a separate machine, so having the password absent in plain text will offer an added layer of security, especially in the case that someone without physical access gets control of the web server. They can break the app (easy to fix/restore), but they can't get to the data behind it as easily.

@Mark: I agree that it's not practical, but in this case security is a bigger concern for me. I don't see any other way of securing the app in the case that someone gets physical access to the machine, or even command line access outside of the web directory. @PFMaBiSmAd: It's not secure in the case that someone gets physical and/or command line access to the machine. It would be sitting right there in plain-text.

Before you do, if ($result_row[6] > "") { make an array, $alerts = array(); and at the same place that you echo, $alerts[] = "$id -$alert @ $location<br><br>"; This will automatically increment the index of the array and build it during the loop. Double check afterward with: print_r($alerts);

show databases gives me the databases I've created, as well as "information_schema". In that database, there's a "tables," uhm, table. It's got info about all the databases and their tables, including a column called "create_time", which will tell you what you want.

I'd like to beef up the security of an app by keeping the mysql password out of any files anywhere. I'd like to input it through the command line once I start up the app and have it read from memory anytime a mysql request is going to be made. Is there a way to do this? Any ideas?