Some Simple Questions (Help)

[Murdok09]

Okay, so I'm trying to implement 4 major things onto my site.

1)User interface that possibly reflects/uses those on the site's forums.
-If I make a new user interface, will people have to re-register?
-Can I make it where all users are automatically signed up for this?

2)Auto-updating database that reflects the time users have spent playing selected games. >Must include "Games", "Progress", and "Related Links"<
-How can I make related links depending on what a user selects?
-How can I make drop-down menus in a database that when selected, are added to a user's profile so that THEY can later change the progress?
-How can I make an auto-updating time chart for "Time Spent Playing Games"?

3)Auto-updating database that contains music, movies, anime, and TV shows . Since I only have one database, I suppose it will be based on the same DB as two.
-How can I make an auto-updating time scale?
-How can I make drop-down menus that say "Watched/Listened", "Watching", etc. that actually change values for time scales/drop down state?

4)Suggestion database that users can say "Hey, I like Pokemon, you'd like Digimon", and on the page for "Pokemon", it will say "__ People think you'd like "Digimon".
-How could I do this?
-How can I implement ratings, suggestions, and comments for the aforementioned DBs?

Lastly, just some general questions.
-How do I make a connect file for my MySQL database?
-How do I add to a MySQL database? Through control panel and MyPHPAdmin?
-How do I put a database on a site?
-Would anyone like some money for helping me?

[Fumigator]

Thos are your simple questions hmm? :rolleyes:

[bazz]

lol.

If you haven't heard it yet, welcome to CF.

That's quite a lot of simple questions. unfortunately, the length of the replies would be longer than the forum allows for posts.

I can suggest that you read up on

connecting to a db,
creating a db,
insert
delete
update
to start with.

your question about whether chaging the interface and if that would necessitate re-registration, suggests you need to read up on 'db structure' or 'what is a db'. registration is a process that inputs to the db. the interface lets web pages communicate with the db. changing the communication with the db wouldn't impact on the db any more than (an analogy), changing the roadway to your house, would change your house.

(I leave aside the wayward digger driver :D )

I think a good starting tutorial would be www.tizag.com

bazz

[Murdok09]

I have a syntax error...
<?
/**
* Constants.php
*
* This file is intended to group all constants to
* make it easier for the site administrator to tweak
* the login script.
*
* Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
* Last Updated: August 19, 2004
*/

/**
* Database Constants - these constants are required
* in order for there to be a successful connection
* to the MySQL database. Make sure the information is
* correct.
*/
define("DB_SERVER", "localhost");
define("DB_USER", "your_name");
define("DB_PASS", "your_pass");
define("DB_NAME", "your_dbname");

/**
* Database Table Constants - these constants
* hold the names of all the database tables used
* in the script.
*/
define("TBL_USERS", "users");
define("TBL_ACTIVE_USERS", "active_users");
define("TBL_ACTIVE_GUESTS", "active_guests");
define("TBL_BANNED_USERS", "banned_users");

/**
*/
define("ADMIN_NAME", "admin");
define("GUEST_NAME", "Guest");
define("ADMIN_LEVEL", 9);
define("USER_LEVEL", 1);
define("GUEST_LEVEL", 0);

/**
*/
define("TRACK_VISITORS", true);

/**
*/
define("USER_TIMEOUT", 10);
define("GUEST_TIMEOUT", 5);

/**
*/
define("COOKIE_EXPIRE", 60*60*24*100); //100 days by default
define("COOKIE_PATH", "/"); //Available in whole domain

/**
*/
define("EMAIL_FROM_NAME", "YourName");
define("EMAIL_FROM_ADDR", "youremail@address.com");
define("EMAIL_WELCOME", false);

/**
* This constant forces all users to have
* lowercase usernames, capital letters are
* converted automatically.
*/
define("ALL_LOWERCASE", false);
?>

[Murdok09]

It appears to have something to do with "localhost", but I don't know what to define that as.

[Murdok09]

localhost is what im supposed to be using, so what's the syntax error?

[Fumigator]

To get help with a specific error, you must include the error with your post. Also, if it is a PHP error, then it should be posted in the PHP forum.