QUOTE
IWhat do I need to name it? I used 'registration' but am not sure if that fits in with the script, though I think it does.
The DB name doesn't matter, really, since you need to add the name to the login configuration for opening the database.
A name such as 'registration' is fine, but might be too long. Remember that the DB name on the Trap17 prefixes the user-name, so try to keep the name under 8 characters and add the prefix. ie: in the config file, the dbname for me would become 'jlhaslip_login' if I called it 'login'.
QUOTE
when I made a database in PHP My Admin it has collation. I do not know what this is. The default seems to be latin but I am American. The only things that looked familiar to me were ASCII and UTF8_unicode.
The collation has to do with the nature of the stored data. The Default collation recognizes most of the Latin-based languages (English, Italian, etc)
I would recommend using UTF-8 since it recognizes all the international characters. Say, for example, a member from Brazil wants to register, then UTF-8 would recognize their input from their Brazilian keyboard complete with accents. I just took a look and the SQL file for the tables is using latin1 for its collation. That would work fine.
QUOTE
$con = mysql_connect('host', 'jlhaslip_user', password'); // host, username, password
mysql_select_db('jlhaslip_jsg', $con); // db name with prefix
This is the connection portion of the file named db.php. Complete the information using the above as a guideline. (no, it will not work on my actual account
) This file is 'required' each and everytime you access the database and caused the DB to be opened using the correct information.
Hope this helps. Post back if you need anything more.
Comment/Reply (w/o sign-up)
( expirince. so if send me what you are looking for, i might be able to find you the perfect script.
