Retrieving Data from Two Different Databases


Posted on 16th Feb 2014 07:03 pm by admin

Hello All,

Ran into another problem and would appreciate some help! I have two databases, publications_db (pub_id, title, author, yr, journal, num_pages) and activity_db(member_id,pub_id,date). Basically, when a user is logged in, I want to have an option for them to view the publications they have submitted to the publication database.

Did you know?Explore Trending and Topic pages for more stories like this.
In pseudocode, I want to display * from publications_db where the session_id (currently logged in user) matches the activity_db.member id AND activity_db.pub_id matches publications_db.pub_id

Below is the code I was writing although I am sure it is completely off because I am quite new to this stuff! Any help would be greatly appreciated!

Quote$dbhost="localhost";
$dbuser="****";
$dbpass="***";
$dbname1="publications_db";
$dbname2="activity_db";
$db1=mssql_connect($dbhost,$dbuser,$dbpass);
mssql_select_db($dbname1,$db1);
mssql_select_db($dbname2,$db1);

$query="SELECT * FROM publications_db P, activity_db A WHERE $_SESSION['SESS_MEMBER_ID'] = A.member_id AND A.pub_id = P.pub_id;";

echo "<table border cellpadding=2>";

while($info = mysql_fetch_array( $query ))
{
echo "<tr>";
echo "<th>ID:</th><td>".$info['pub_id'] . "</td> ";
echo "<th>Title:</th> <td>".$info['title'] . " </td>";
echo "<th>Author:</th> <td>".$info['author'] . " </td>";
echo "<th>Year:</th> <td>".$info['yr'] . " </td>";
echo "<th>Journal:</th> <td>".$info['journal'] . " </td>";
echo "<th>Pages:</th> <td>".$info['num_pages'] . " </td></tr>";

}

echo "</table>
";
echo "$count_entry Total Entries";

?>
No comments posted yet

Your Answer:

Login to answer
132 Like 8 Dislike
Previous forums Next forums
Other forums

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

Big O & time complexity ???
can you help me how to calculate the Big O & time complexity for any algorithm and c++ program pleas

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

pointer 102 question
I read a book
1
2
3
4
5
6
7
8
9
10
11
12
int main() {

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been

Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash