Hey - is it possible to have 1 config file, connecting 2 databases. eg:
Language: PHP
<?php
$host="127.0.0.1";
$username="root";
$password="";
$db_name="registration";
//first database called registration with 3 tables.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
//second database called user with 1 table - user
$userdb_name="user";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$userdb_name")or die("cannot select DB");
?>
I wonder if I read the question correctly:
You then need to add a database user to the table user in the mysql database in phpMyAdmin, giving him certain rights (e.g. add, edit, delete etc), and then link this user to your registration database, in the db table. This user and password is defined in the config file. Google for help on adding database users via phpmyadmin.
1. how do you link tables
2. how do you grant rights in phpmyadmin
3.do we have submit an SQL dump for this table? otherwise how is Mac going to know if we gave rights and linked tables?
4. should he not have users table in his Database or if he creates it differently, the system will crash. worse case is if you lock your pages so that only users who are logged in can use it, he will never see your system running even though he marks the code. but still...