Adding Two Databases to SQL Query

stevek93 · 21-04-2015 5:38pm #1

Hi all,

I am trying to add two tables from the same database into my website using the following code

$SQL_Query = "SELECT * FROM public WHERE uname = '".$username."' AND id = $ID";

I have another database named admin, were do I add this?

21-04-2015 8:51pm

[PHP]$SQL_Query = "SELECT * FROM public WHERE uname = '".$username."' AND id = $ID";
$SQL_Admin = "SELECT * FROM admin WHERE ...";[/PHP]
Or possibly:
[php]$SQL_Query = "SELECT * FROM public LEFT JOIN admin ON public.id = admin.id WHERE public.id = $ID";[/php]
TBH, you're not providing anywhere near enough information. What do you mean by "adding a table to your website"? Do you want to take the SQL table and just display it as a HTML table? What are you currently doing with $SQL_Query?

Seth Brundle · 22-04-2015 3:52pm

I see that Google is back online now!

On the assumption that you are trying to create a join, then have a look at these.
http://nathan.rambeck.org/blog/2-joining-mysql-tables-across-multiple-databases
http://stackoverflow.com/questions/5698378/mysql-join-between-tables-in-2-different-databases

If they are going to be used independent of each other in the page then there should be no difficulty!

Adding Two Databases to SQL Query

Comments