Just use MySQL_select_db() to switch between databases between your
queries. Remember to switch back, too.
Or you can just give the database name in your query:
SELECT * FROM database.table WHERE ...
---John Holmes...
-Original Message-
From: d3crypt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 5:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Multiple queries on multiple databases
Hello,
I'd like to know the method to connect and query multiple databases in
the same php script ...
I've to do something like this :
do query on db1_on_server_1
while( get results of query on db1_on_server_1){
do query on db2_on_server_2
}
the structure of the db is this one :
# Table structure for table 'attendees' in db 'training2'
#
CREATE TABLE attendees (
attendee_ID int(8) NOT NULL auto_increment,
training_requester_ID int(8),
PRIMARY KEY (attendee_ID),
UNIQUE attendees_ID (attendee_ID)
);
# Dumping data for table 'attendees'
#
INSERT INTO attendees (attendee_ID, training_requester_ID) VALUES (
'1', '299');
# Table structure for table 'people_info' in db 'octopus'
#
CREATE TABLE people_info (
id int(255) DEFAULT '0' NOT NULL,
l_name varchar(255) NOT NULL
);
# Dumping data for table 'people_info'
#
INSERT INTO people_info (id, l_name) VALUES ('299', 'Forseilles');
I've tried the following script, but it gives me a 'Warning: Supplied
argument is not a valid MySQL result resource in
g:\htdocs\training\viewmytrainings.php on line 23' :
?
$octopus=localhost,,,octopus;
$training=localhost,,,training2;
function connect($database){
$array=explode(,, $database);
$host=$array[0];
$user=$array[1];
$pass=$array[2];
$db=$array[3];
$connect=mysql_connect($host,$user,$pass) or die (unable to
connect host $hostbr);
mysql_select_db($db) or die (unable to select $db in
$hostbr);
return($connect);
}
$connect1=connect($training);
$connect2=connect($octopus);
$query=select * from attendees order by training_ID asc;
$result=mysql_query($query, $connect1);
$row=mysql_fetch_row($result);
echo $row[1];
$queryx=select l_name from people_info where id='$row[1]';
$resultx=mysql_query($queryx, $connect2);
$rowx=mysql_fetch_row($resultx);
echo $rowx[0];
?
Any idea ? Thanks for your help ...
(PHP Version 4.0.6)
--
d3crypt aka p
$ drink bottle; opener
bottle: cannot open
opener: not found
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php