BMurtagh

Hi Josh, The rewrite rule you'll want to use in the .htaccess is: RewriteEngine On RewriteBase / RewriteCond %{HTTP_HOST} domain.com RewriteCond %{REQUEST_URI} !<subfolder>/ RewriteRule ^(.*)$ <subfolder>/$1 [L] Save the changes & you should be good to go

The best way to do this would be to read up on data normalization for MySQL database design (It sounds worse than it is) but this will get you thinking in a more programming/design-orientated state of mind. The reason for this is because you want to keep a record of past pricing. The way I'm picturing your table design is: tblOne - Object Name - Object ID (PK) - Date - Daily Minimum Price - Daily Market Price - Daily Maximum Price tblTwo - ID (PK of tblOne) -- should pull the data from tblOne w/ the min, market, max & date Once you have the data in there you can just increment the rows at the end of each day from the data in tblOne. This just my 2 cents, but below are some URLs to info about data normalization: http://www.devshed.com/c/a/MySQL/An-Introduction-to-Database-Normalization/ http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html http://www.developer.com/db/article.php/3667831

Hey, If you have the mysqldump of the database you can restore it over the current database from command line. Once SSH'd on to the server use the following command: mysql -u [uname] -p[pass] [yourdatabase] < [backupfile.sql] This will restore the backupfile.sql to your database from command line. If you're using PHPMyAdmin follow these instructions at http://www.webcheatsheet.com/SQL/mysql_backup_restore.php#phpmyadmin

Hi leoashcraft, The best method to troubleshoot would be to get access to the Apache error log for the website. Most hosts will grant you access to your site logs depending on how they have their clients setup. Within the error_log there should be some PHP notices/errors that can give you more information as to why the page isn't functioning properly & go from there.

Hello, You're going to want to use PHP and create a while loop after finding out the max # of rows of data in the DB table. $sql = "SELECT * FROM <table>.<database>" $res = mysql_query($sql) or die; $num = mysql_numrows($res); /* that should get you the # of rows stored in $res */ Next would be to create the loop to insert the data into the new table: $i=0; while ($i < $num) { $sql = "INSERT INTO <table>.<database> SELECT <table>.<database> FROM <database>"; $res = mysql_query($sql) or die; $i++; } I have not had the ability to test the code as of right now, but this should at least get you on the right track for accomplishing this. Check this out and reply back if you have other questions

Hello, The backticks (`) should be the proper formatting for this according to PHP's legal-names. However, can you set the code to use the backticks and copy the error to here? I think pasting the exact output error and/or the apache error_log would help those who view the thread more info to help out.

Hi, The best method would be to enable SMTP logging from within IIS Manager. Once you've enabled the logging of the SMTP traffic for the local mail server, you can then use you PHP mail() test page & check the log. Below is a quick script mail() example if needed: <?php if(mail('[email protected]','test subject','test message')){ echo('ok'); } else{ echo('not ok'); } ?>

Hi, You're going to want to use LDAP on the Linux box in conjunction with the Active Directory that's already setup. PHP has a pretty decent amount of info on the various functions related to LDAP on their website at http://us3.php.net/manual/en/book.ldap.php. I also found a pretty interesting article at http://articles.techrepublic.com.com/5100-10878_11-5032010.html that you might be some extra info for getting you started.

Hi, After doing 'which autoscan' if it comes back as not found, you'll want to install autoscan. To do so, see below: 1. sudo to become superuser 2. Run either: sudo aptitude install autoscan OR sudo apt-get install autoscan These will install the autoscan package from the repositories setup on the Linux box. If you want to make sure your packages are up to date, you can run: sudo apt-get update Run this command after changing /etc/apt/sources.list or /etc/apt/preferences . This command periodically to make sure your source list is up-to-date.