surefire

Thanks for the prompt reply... what was that, five seconds? And thanks for the offer, can I PM or IM you? Or would you prefer thread? My site is quite large and it is consistently devoted to only one theme... so I was thinking this would be good. Please point me in the direction of making the most of all these pages I have. How do I use the cpanel, or any other tool, to find out which IP was used by Google? Thanks for all your help.

I'd also like to add that one of the TCH members has a very resource-rich site for js http://www.cmg02.com/scripts/navigation.htm I saw this site on the TCH forums and immediately bookmarked it.

Well, Google came back and looked at 1041 more pages. So, maybe this is freshbot... I can't tell because I don't know how to use Awstats to view a list of all IP's. I tried to download the raw log file, but it wasn't in a format I could decipher. Dsdemmin, or anyone else, maybe you could give me some much needed help in deciphering which IP Google was using. If memory serves... Freshbot starts with 64. and deepcrawl is 203 or 212 or something like that. Thanks. PS - Even if this isn't deepcrawl, still about 1041 more pages worth of activity then I've ever received before. So I'm pretty pumped. PPS - Dsdemmin, how long would you estimate would be the time (typically... I know it's a guess) from Freshbot to Deepcrawl to those deepcrawl results showing up in results. I would guess one month from Freshbot to Deepcrawl, and then one more month after that for results to show up. But I'm guessing.

Yes. You can use the dumpfile by pasting it right into the SQL field in phpMyAdmin. It will create all the tables and populate it with data, assuming the dumpfile is written correctly. I've had to restore a database before and that's exactly what you do. Now the dumpfile I was using was made by phpMyAdmin... but there's no reason I can think of why this wouldn't work for you.

My understanding is that freshbot can swing by a site several times a month to get updates on pages already in Google's index. Deepcrawl happens once a month (or at least used to) and it searches for new pages by following links within your site. I don't quite understand why it wouldn't follow every single link the first time... but apparently Google's spider grabs more pages with each successive deep crawl. DSDemmin has written several tutorials on this topic in the forum and in the main TCH website. Since Google checked out 513 of my pages, I'd guess that's a deepcrawl.

Okay. I downloaded the script to take a look at it. From what I know (and I certainly don't know everything ) it appears that you are supposed to run this setup code from the 'command line' of mysql. Since I've used phpMyAdmin to install every single script I run, either borrowed or home brewed, I really can't tell you how or even if it can be done from CPanel. If it were me, I'd probably look for another script. But since you've indicated that you are very intent on setting up this script, I'd say that you could very easily create the database and table one by one in phpMyAdmin. There are only five or so tables and they're very small. Another option would be for you to email the creator of the script at Sourceforge.net There's a small possibility that he would send you a text file with the code you could paste into phpMyAdmin. If somebody else can help out Mav2u, please step in and take over for me...

With all of the craziness surrounding Google right now, I was thrilled to see that Google finally visited several hundred of my pages. Although the 513 page visit is less than 10% of the site... I'm not compaining. Maybe in a month or two I'll see some solid ranking results... who knows. Other good SEO news... my wife's website is #1 or #2 on Google for about 9-10 of her best search terms! Maybe I know what I'm doing after all... Nah. That can't be it. PS - At first glance, this post would seem to have zero relevance to anyone... except for the fact that bizarro things have been going on with Google lately testing new ranking algorithms. So maybe this indicates that the new month long dance or whatever they're doing is over. Should be interesting.

dsdemmin: I've got that book and it's all dog eared from looking up esoteric scripts that fit a particular need. At first, I didn't think I'd get that much out of it. It seemed pretty advanced... and it is. But it's so useful to see code written by others.

Darn good suggestion matman Somewhere I even found a PHP script that would somehow check the validity of an email address BEFORE sending out the email. Somehow it could verify the address was 'good' most of the time. But the point is: don't trust user input to be safe or in the format you expected.

There are probably tools to change permissions in CPanel but there are definitely dozens of free ftp tools that allow you to do it. I use FTP Surfer and WS FTP. Surfer is easier to understand, but WS FTP has features that the other one doesn't have. For this job, I'd suggest FTP Surfer. It's free. http://www.whispertech.com/surfer/download.htm

I am thinking the same thing as leezard... you have to create a user AND assign the user to the database. Two steps when it would seem like only one.

In phpMyAdmin, you go to the main screen that comes up, and you hit the 'SQL' tab. This gives you a form where you can post that code into the text box. Hit the submit button. Your tables are created. That's also how you could repair a damaged database with a 'dump file' aka backup.

The way I would do it... would be to use phpMyAdmin to create the database and set the password. That's basically what it's saying here... but it doens't want to assume that you'll have phpMyAdmin... which makes life so much easier. Take a look at the post I put in the scripting forum called 'How to set up a MySQL database." I'd give you a link... but I'm literally running out the door this second.

I'm feeling all sorts of loved and appreciated! Thanks for the kind words.

I haven't had time to read the whole article, but it looks like cerealkeeler found what we're looking for. Thanks.

This is something I've never tried before. But I bet we can figure it out. Why don't you do this... go over to the scripting forum and start a thread by stating your question and posting your php code for the page (if you don't mind). That way, I can see what you're trying to do. This will also require modifying htacess either directly or through the cpanel. I don't see why a custom error page couldn't be php... but others seem to think that it can't. I'd like to give it a shot. I'll research it a little bit and get back to you.

I didn't want to be the first to start the 'show and tell' ... but I'll jump in to get the ball rolling. Jobs Wanted/Jobs Avail On this page, Travel Nurse Depot Jobs There's a lot going on behind the scenes. First, I use php include() to bring in the header and footer portions. You'll notice that the header has date. That's a short snippet of php code right in the header file. What you might not notice, unless you navigate around the site, is that there are two logos I use. Currently, the php script in the header file generates a random number that determines which logo gets displayed. So you might revisit a page and see a totally different logo. (Think about the ways that type of code could be adapted... ) Then, in the body of the page, I've used include() to bring in the four main sections. Each of those four files runs a query on my database, pulls out a certain number of job postings, ranks them in the order I ask, and displays them in tables. I used css to get the dotted line around the three boxes. At the very bottom of the page, there is a footer section that is included by php. In it, there is a drop down select that submits to a page that does nothing more than redirect to the page selected. I used the header() function to make the redirect happen. You could view source on the form to see the drop down values, and you'd get a good clue of how it was written. Pretty straightforward... but home built. The database script that pumps out the 50 main job requests also puts in an extra snippet in the 'a href' html code that says The end effect is that when you hover your mouse over the job listings, a little information box pops up that gives the recruiter more info about the job request. Then the R boxes that are next to some of the job listings indicates that some of the job hunters have resumes on file. So, if you follow the link to their profile, you can click on the icon (R box) and an Adobe Acrobat file will pop up on your browser that is populated by information from my database. Comparing apples to apples This page: Compare Agencies Is populated with information from a database that some of my visitors put in for me. The page populates the drop down select boxes with information from the database so that any time a new entry is made, the form automatically updates without any effort on my part! (See why I love php?) Then, the script submits the user input to the same page using $PHP_SELF Up comes a side by side comparison of the companies. Other general ideas I won't go through the other pages, but here is a bullet list of ways that I've used PHP to create a content rich site: Password protected pages (using php, not htaccess) Forum with private messages Email automatically sent out composed of html triggered by certain events List of all the hospitals in the us, with paginated menus so that users can select by city or page number Dynamically generated urls that enable me to show weather and maps in any city they choose, and I only had to write a few lines of code A tell-a-friend form that asks the user how many referrals they want to give, and then populates the next form with only that many fields... sends out email to referrals as if sent by the referral giver Well, if I pat myself on the back any more, I'll risk breaking my arm. I'm looking forward to seeing what the rest of you come up with. It doesn't have to be unique or amazing... just something you're proud of... even if it's just getting your first PHP script to work. We'll give you helpful suggestions.

Try this thread that I started today in the Scripting forum http://www.totalchoicehosting.com/forums/i...=ST&f=59&t=2399 Not the end all and be all of db info... but it should get you going in the right direction. Follow the suggestions to other resources and it should be pretty easy. If you still need more help after trying the suggestions in that post then let us know where you get stuck.

Most welcome.

When I go to this page... http://www.maxgrad.net/links/links.php It looks like everything is fine and working. But the error message you pasted was indicating that the config.php file was not found in the location your code told the server to go look. Gemini, I'm a little puzzled about how to help you further. I don't feel like I have a good handle of what you're looking for. Do me a favor... this thread is getting a little long. If you want more help, please start a new thread in the Scripting forum and I'll see what I can do to help.

Gadzooks Hopefully, you meant any other BIG corporation. Don't lump well meaning entrepreneurs in there.

Please copy the error message so we can look at it.

I'll try to quickly cover main concepts in connection to your database so that 1- Your website security isn't weak 2- You can quickly change your username and passwords if need be 3- Your code is portable to another website (why do the same work twice?) Please understand that there are a million and one tutorials on writing PHP scripts that store, sort, and retrieve information in your database. I won't cover this in depth, but will provide a few good links for further study. First, you need a database. There is a great movie tutorial that explains setting up the mysql database from cpanel: http://www.totalchoicehosting.com/help/moviepage.htm When you set up your database, and assign users to the database, cpanel prints out some code that you can copy and paste into your php code... don't. We're going to connect in a way that saves you time and creates a more secure website. Setting up your "keys" Let's create a file, in this example we'll call it keys.php You can call it whatever you want, but I strongly suggest you end it with .php Here's what it's going to look like: The items in bold need to be replace with the actual information for your database. That's it for our keys.php file. Now we need to find a home for it. Where to store your keys Ideally, you want to make it a little tougher for someone to access your file. The fact that we saved our keys file as php is a start... but let's go one step further. We're going to create a new folder in our ROOT directory. In other words, it will NOT be inside our public_html folder. We're going to place it OUTSIDE the publicly accessible files. So go ahead and ftp to your site, and create a folder in your root directory. In this example, I'll call it 'safe' Now all we need is a way for our php pages to grab the keys right when we need them. Grab your keys Let's create a page that will connect to our database. In this example I'll call it connect.php The only thing you need to change in this script is the bold part which is the username that you use to ftp to your site, log in to your capel, and everything else at TCH. Unless there is something different about your site, this should be the correct directory location of your site root. Taking it a step further Let's ftp this connect.php file to our website and put it in our main public_html folder. You can put it wherever you want, so long as you adapt the rest of these instructions to point to the right location. Now, on any page that we want to connect to our database, we can put Learning SQL Great resources at the TCH help page. Also a great tutorial at DevShed *Note. the term 'keys' is not a php term and was made up for this tutorial to be witty.

No... as long as links.php works... which it appears that it does, then we're good to go. What I need you to do is to create a separate folder that you will keep open for TCH users so they can see how we created your pages. You can call the folder anything you want, but I need to know, so that I can link to the example pages. You also need to post the code that I send to you and put it in your folder for other TCH members to see and learn. The folder doesn't have to be accessible to your other visitors, only TCH members will know where it's located. Deal? If so, I need to know: 1-the name of your folder (call it 'tch' if you want) 2-the links you want for your menu... or html code for the menu... either one Then I'll announce the new thread (discussion) where I'll work on your pages and create a tutorial. I'll wait for your response.

1- First, you'll likely need something to unzip the files. There are plenty of free utilities on the net. I use PowerArchiver But WinZip is a favorite too. 2- You'll need to find a good script. Although there are plenty of sites out there, the thing I like about HotScripts is that you can read reviews from other members. 3- Download the files to a folder on your computer that you'll be able to locate easily. Think about either a 'Download' folder on your desktop or in your 'My Documents' 4- Unzip the files to a folder on your computer dedicated to scripts... or make sure you'll be able to find the files later. The files should unzip if you double click on them and your software is installed correctly. 5- You want to look for a file called "Readme", "Instructions" or a folder called "Docs" 6- The text file should have instructions for installing the particular script. It might help to open the file in WordPad, rather than Notepad. WordPad will format the text file in a way that is easier to read. 7- A good script will have easy to follow instructions, a FAQ (Frequently Asked Questions), and a support forum where you can ask questions. But understand that if you are getting a script for free, don't expect hands on help from the author. Luckily, some help forums, like the one for phpBB script and OSCommerce, have tons of helpful users... just like at TCH 8- I won't cover how to install a database in this thread... but I'll start a new thread on setting up a database.