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

Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be

Captcha problem users just refresh and it will let them auto submit again
Users will just re submit and not have to enter the new captcha.. ? Lol but if i refresh the page, t

Need a fuction to count entries in a field
Hi
I need a fuction to count how many times a email address is entered in to a field.

I ma

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

Problem with PHP/mySQL login code
Hello,

There is an error in my login script and I can't figure out what it is...
I believe

Unable to retreve the values from Mysql Query
Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resu

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

Echoing If Function?
A script I am using has If statements in the comments form to basically tell the form what to do. Cu

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