Mysql Help Oh please help a poor little girl...

[Becca 0]

Hello....I am crap at making websites and I don't even know how to use MySql. I don't even know what it means.OK FIRST OF ALL DON'T GIVE ME SOME WEBSITE TO GO TO because I WONT.
Anyways the problem is well this is a page of my banner rotation websites
http://forums.xisto.com/no_longer_exists/
and well why does it say 0: bexa_mysql ???
WTF does it mean ?
I aint got a clue and hopefully all you computer genius' out there can help me. If you can't don't worry I will just pray to god for it to hopefully change it self the next time I go on it.

Thank You x

Bexa

[serverph 0]

well, the best person who can help you is the one who developed that code (in your case, phpwebscripts).

[Becca 0]

nooooooooooooooooooooooooo I had to create the database fields my self for the first time...And I dont even know what I have done...

[serverph 0]

delete the database you created yourself for this script. follow instead the instruction

provided in the README.html that came along with the script.

 

Installation

Upload all files onto your server.

Set permission (chmod) of the data directory to 777

Run setup.php. It installs the table we will need and creates some files.

Go to the admin area (both username and password are 'admin') and set all variables.

Now you can start to use the script. New users may join by going to 'join.php', existing users can edit their accounts and see statistic at 'member.php'. Each new user must be enabled by admin. Until the user is not enabled, his/her banners are not shown.

 

when you still have a problem, just holler.

[Becca 0]

yaa I know I read it all ages ago but when I go through the setup it does every thing and at the end it says ERROR 0:bexa_mysql.....which is well I dont know what it is.....but it doesn't install the databases and fields...

[serverph 0]

hmmmnn... let's do a rundown of things which you may have missed. upload your

files in folder of your choice. then:

 

1. go to your cpanel.

2. go to mysql page, and click on phpmyadmin on the bottom part of the page.

3. after phpymyadmin pops up, create a new MYSQL database on the left panel.

NOTE: your db will be prefixed with your subdomain_ (example: bexa_bannersql)

4. close phypmyadmin. refresh mysql page. your new database should appear there.

5. check that you have an existing mysql user on the bottom part of the page.

if none exists, create one. it will be prefixed again with your subdomain_ (remember the password you use here).

6. Grant permissions on a MySQL database to a MySQL user. (just above the

existing mysql user in #5). leave Privileges setting as it is. then toggle to grant

permission of a USER to the MYSQL DB you created earlier.

7. After page refreshes, you would see a set of connection strings applicable to

the DB. Check the PHP syntax there.

Example: $dbh=mysql_connect ("localhost", "yoursubdomain_dbusername", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("yoursubdomain_dbname"); 

8. Proceed with setup of your php script at this point with the details you now have.

Mysql database host (try 'localhost' if you are not sure): localhost

Your mysql database username: yoursubdomain_dbusername

Mysql database password: password

Name of your mysql database: yoursubdomain_dbname

Full path to the folder where the scripts live. It should be correct value so please don't change it if you are not 100% sure it is incorrect. No trailing slash.: (see GENERAL SERVER INFORMATION on the lower left side of your cpanel)

that should cover it all, i guess.

[Becca 0]

sorry um I have already done that thank you for helping any ways.OH NO WAIT MAYBE I HAVENT COULD YOU LIKE HELP ME BY LOGGING ONTO MY USER ? I KNOW IT IS RISKY BECAUSE YOU MIGHT DELETE ME FILES BUT I DONT CARE... HELP ?

[serverph 0]

sorry um I have already done that thank you for helping any ways.
OH NO WAIT MAYBE I HAVENT COULD YOU LIKE HELP ME BY LOGGING ONTO MY USER ? I KNOW IT IS RISKY BECAUSE YOU MIGHT DELETE ME FILES BUT I DONT CARE... HELP ?

try to work on it for now. i'll try to setup the same script locally on my PC, then
test it. it's risky what you're asking heheheü i'd rather walk you through the
setup after i test it on my side. i will help you within 24 hours or so, as i'm about to
log off already and it may take some time to reconfigure your setup.

[Becca 0]

ahh bugger thanks!!Im hungry I need to go bed its 11:30pm *yawns*