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 $host<br>");
mysql_select_db($db) or die ("unable to select $db in
$host<br>");
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
