note 45868 added to function.mysql-query
| From: | kenneth at ks81 dot com | Date: | Wed, 22 Sep 2004 03:39:42 +0000 |
| Subject: | note 45868 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-77136@lists.php.net to get a copy of this message | ||
For use with to databases in one query:
$dbcnx1 = mysql_connect ( 'localhost', 'username', 'password',
'dbcnx1')
$dbcnx2 = mysql_connect ( 'localhost', 'username', 'password',
'dbcnx2')
$db1 = mysql_select_db ( 'db1', $dbcnx1)
$db2 = mysql_select_db ( 'db2', $dbcnx2)
$sql = 'SELECT db1.tbl1.row1,db2.tbl2.row2 FROM db1.tbl1,db2.tbl2';
$array = mysql_fetch_array(mysql_query($sql));
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+45868
Delete -- http://master.php.net/manage/user-notes.php?action=delete+45868&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+45868&report=yes
Search -- http://master.php.net/manage/user-notes.php