very basic php/mysql help needed.

[wen_laat]

I'm a total newbie when it comes to mysql. I wanted to create a faq page that I could edit online. Now I've found this: http://www.technetguru.net/design/faqmasterflex.php

I think I've created a database, and I can look at the index page: http://www.typicaldutchstuff.com/FAQ...Flex/index.php

But it doesn't connect to the database. I think the problem lies in config.php This is my code:

<?php

$link = mysql_connect("localhost","root","");
mysql_select_db("faqmasterflex");

$username = "blablabla";

$password = "morebla";

?>

What do I have to change? I have tried so many thing, but it just doesn't work.

[ronniethedodger]

In this line of code:

$link = mysql_connect("localhost","root","");

you will need to supply your MySQL username and password in order to connect to your database.

Think of it like this:

$link = mysql_connect("localhost","username","password");

Leave the first parameter ("localhost") just as written. Fill the other two in accordingly.

Whatever you do ... never post your username and password publicly.


Part Two

Change this part of the code back the way it was.

$username = "admin"; 

$password = "admin";

You will be provided an option once you log into the admin panel for the script to change the Admin password.

This username and password is different than the MySQL username/password.

[wen_laat]

thank you for your help. I've changed the settings, but when I go to my config page to log in, I just get a blank page. I'm completely lost with this, it's so frustrating. What else could I have done wrong?

[ronniethedodger]

The only thing I can thing of is that you are not connecting to your database.

I cannot read Dutch. But I am looking at your hosting plans and it does not appear that you have MySQL.

How did you set up the database originally?

The instructions for installation:

Create a MySQL table, preferably faqmasterflex, then copy and paste SQL from faqmasterflex.sql info with your favorite GUI SQL tool (phpMyAdmin).
Open faq_config.php and change MySQL connection variables.
Upload contents of PassMasterFlexPlus to your web server.
Login using (if not changed in faq_config.php):


Username: admin
Password: admin
That's it!

If you have access to this database, can you verify that the tables 'faqcategories' and 'faqs' are present in your database? The database name should be 'faqmasterflex'.

[wen_laat]

well, I do have MySQL, 'onbeperkt' means unlimited, so I have plenty to spare. But I got so frustrated with the whole thing, I gave up. Yes, I'm weak, I just figured something else out, and created this:
www.typicaldutchstuff.com/faq.shtml

just what I wanted, and sooooo easy! ;)

[skypower]

I am no expert, but the location for the database is not alway "localhost" check with your isp, as mine if different.

[hnofal]

If you need help with your programming needs, we can help you. Please fee to email hoda nofal romano at support@globalwebsolutions.com

hoda nofal romano