How to select from mysql db php

Question

Are these 2 equivalent, if not how can I make them. I'm using php/Mysql (I'll use mysqli later)

mysql_select_db("db_App", $link);

$result = mysql_query("SELECT * FROM AppOne");

OR

$result = mysql_query("SELECT * FROM db_App.AppOne"); // how can I get this to work like above?

I really wouldn't use the mysql_* functions if I were you, they're not being maintained anymore, are intended for old versions of MySQL and are deprecated in all but name. You should switch to a more modern database layer such as mysqli or PDO — GordonM
– GordonM, Commented Jul 11, 2012 at 8:59

Sherlock · Accepted Answer · 2012-07-11 09:00:30Z

2

You'll always have to select a database. From then on, specifying the database in the query is useless. It's better not to specify it there anyway, as that'd make you run into troubles if your database changes at some point.

answered Jul 11, 2012 at 9:00

Sherlock

7,6356 gold badges42 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sebi Over a year ago

Well then how do I use join, that requires 2 different databases?

Puggan Se Over a year ago

no, it works fine whitout selecting a database, as long as you specify the databse in each query

Sherlock Over a year ago

Joining is usually done on tables in the same database, so specifying is redundant. If you're trying to join tables in multiple databases, reconsider your database model.

j0k · Accepted Answer · 2012-07-11 10:30:28Z

1

if you skip the $link in mysql_select_db("db_App", $link); they should do the same.

edited Jul 11, 2012 at 10:30

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Jul 11, 2012 at 9:02

Puggan Se

5,8462 gold badges25 silver badges51 bronze badges

Collectives™ on Stack Overflow

How to select from mysql db php

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related