Mysql Database Help need help with MySQL databases...skip to page three

[Dayzed 0]

Okay, thanks.But, there is a couple more problems, where do I upload the rest of my site script? In a seperate file? I have about 30 more files I need to upload, all of which are needed. Do I do it in a seperate file than index.php or in the same one? There is a footer that is needed on all pages and none of the site works without it. And uh, since your helping, you still want an admin position correct? Or are you doing this out of the kindness of your heart?

[snlildude87 0]

uploading all your files into the public_html folder should work. every file goes into your public_html folder.being a moderator here is good enough

[Dayzed 0]

Yeah, it probably is. When the slow as heck dial up allows me to uploade my files, I will tell you how it goes.If you make me blow it up, its your fault...

[Dayzed 0]

Also, I have a file called sql.sql. Do I put it in the same place?

[snlildude87 0]

It all depends. If you call sql.sql using an absolute link, then it shouldn't matter where you put it, but if you call it using a relative link, then you have to put it in the correct folder.How do you call it in another file?

[Dayzed 0]

Whats an absolute link? Okay, okay, I lied, not the last question....

[snlildude87 0]

Absolute is where you call your sql.sql file using the full path.

<?php include("http://blah.trap17.com/sql.sql");?>

^ That's an example of an absolute call in PHP

<?php include("sql.sql");?>

^ That's relative, and it will work ONLY if the calling file is in the same directory or folder as the sql.sql file.

[Dayzed 0]

I think I get what your saying, not sure though.I tried moving it around, all over the place, and an error message comes up. Go to here to figure out what I'm talking about:http://forums.xisto.com/no_longer_exists/ dont know what is wrong. I triple checked everything, and it seems to be correct....

[snlildude87 0]

Well, I have 0 experience with MySQL because I find it to be unreliable - PHP never goes down.What's the content of you config.inc.php file? Post the entire code (if it's not large) here

[Dayzed 0]

<?php$_CONFIG['mbname']    = '';    // Giga Pass$_CONFIG['mbsurl']     = '';    // [url=http://gigapass.trap17.com]http://gigapass.trap17.com[/url]$_CONFIG['dbhost']    = '';    // Xisto.com$_CONFIG['homepage']   = '';    // [url=http://gigapass.trap17.com]http://gigapass.trap17.com[/url]$_CONFIG['legal_tags'] = 'b|i'; // HTML tags allowed in messages. You can only add tags that have no attributes.$_MYSQL['dbhost']      = '';    // localhost$_MYSQL['dbuser']      = '';    // dayzed_ejashby$_MYSQL['dbpass']      = '';    // (I put the password for dayzed_ejashby here)$_MYSQL['dbname']      = '';    // dayzed_SQLdatabase//// User level definitions//define('Inactive', 0);define('Warned', 1);define('Mutie', 12);define('Rookie', 15);define('Veteran', 18);define('Idol', 30);define('Moderator', 52);define('Administrator', 60);//// Include money (Coins) configuration. Go edit that file.//require 'mny_config.php';$db = @mysql_connect($_MYSQL['localhost'], $_MYSQL['dayzed_ejashby'], $_MYSQL['(password for dayzed_ejashby)']) or die("<b>Error:</b> Failed to connect to database host: {$_MYSQL['localhost']}<br />        <b>Possible Solution:</b> Check if the database host name, user name and password are defined        correctly in the config.inc.php file.<br />        <b>MySQL says:</b> ". mysql_error());@mysql_select_db($_MYSQL['dayzed_sqldatabase'], $db)or die("<b>Error:</b> Failed to select database: {$_MYSQL['dayzed_sqldatabase']}<br />        <b>Possible Solution:</b> Check if the database is set up and the database name        defined in the config.inc.php file is correct.<br />        <b>MySQL says:</b> ". mysql_error());?>

Where my password is supposed to be, I have my password, not the text.

Notice from snlildude87:

Placing your code in BBCodes makes it so much easier to read

Edited April 9, 2005 by snlildude87 (see edit history)

[snlildude87 0]

Hmm, did you put mny_config.php (as well as every other files) in your public_html folder? If you did, then I don't know where to go from here because I have not worked with MySQL...

[Dayzed 0]

Yes I did....*cries*So you can't help me anymore? Do you know anyone who can?

[snlildude87 0]

I can help you one last time: by changing the thread title to make it look more appealing.

[Dayzed 0]

I cant edit it, and if I can I dont know how.

[Dayzed 0]

Oh, thanks. I thought you ment me....