Query 2 Databases

Anon

Hi all,
ok, Im kind of new to PHP, but was doing ok until I hit this problem. I am trying to build a script that queries two databases to check the existence of a phrase(its use to store project names).

I figure the flow would be as follows:

User enters Enters phrase into form ($phrase)

2.Check Database 1: Does $phrase exist (exact match, NOT case senstive)
If YES: FAIL got to Step 5
If NO: PROCEED to Step 3

Check Database 2: Does word exist
If YES: FAIL go to Step 6
If NO: PROCEED to Step 4
Display "You can call your project that"
Display "Phrase is in use by another project"
Display "Phrase has already been reserved for use"

Can anyone help me build this script? Please keep it simple as I get lost easy!

Thanks

Alicia
xxx

aspbyte

If i can get what you are talking about then
this is the way i solve it

Lets assume that you have a table of existing names with sr(Serial) as a primary
key autonumber field

the other field s in the table are fname , mname, lname , usertype , login , password
Login and password can be replaced with what you want

$login = strtolower(trim($login));

$fname = ucfirst(strtolower($fname));
$lname = ucfirst(strtolower($lname));
$login = strtolower($login);
$password = strtolower($password);
// strtolower bring s alll to smaller case

// This part checks the Validity of the User name for duplicates..

$connection = mysql_connect('host','dbuname','dbpwd')
$check = "select uname from users where uname = '$login'";
$res = mysql_query($check,$connection) or die($error_result);
$exists = @mysql_num_rows($res);
if ($exists ==1)
{
echo $error_login;
exit;
}
else if ($exists == 0)
{
$sql = "insert into $tname1 Values('','$fname','$lname','$login','$password','$dept','$time','$ip','$usertype')";
$result = mysql_query($sql,$connection) or die($error_select);

Hope this helps you

Pradeep
Aspbyte Creations

Anon

Ive just looked teh code over, but I cant seem to find a part that would check the second database?

Is it in there?

Thanks

Alicia