Mysql Query with two tables php

Question

I was wondering how to do a query with two tables in php?

I have this single query

?php 
$sQuery = "Select * From tb_columnas Where col_Status='activo' Order by col_ID DESC";
$result = mysql_query($sQuery, $cnxMySQL) or die(mysql_error());
$rows_result = mysql_fetch_assoc($result);
$total_rows_result = mysql_num_rows($result);

if ($total_rows_result > 0){
    do {
            $id_columnas = $rows_result ['col_ID'];
            $col_Titulo = $rows_result ['col_Titulo'];
            $col_Resumen = $rows_result ['col_Resumen'];
            $col_Fecha = $rows_result ['col_Fecha'];
            $col_Autor = $rows_result ['col_Autor'];
        ?>

But I'd like to compare the col_Autor with au_Nombre which is in another table (tb_autores) and get au_Photo and other values from it, how can I do that?

Google MySQL JOIN. Also, the mysql_ family of functions has been deprecated. That means they will be removed in a future version of php. You should replace them with either the pdo functions or the mysqli functions — Nathaniel Granor
– Nathaniel Granor, Commented Jul 9, 2013 at 3:20
sidenote: stop using deprecated mysql_* functions. use MySQLi or PDO instead. — Raptor
– Raptor, Commented Jul 9, 2013 at 3:20

DevZer0 · Accepted Answer · 2013-07-09 03:29:10Z

3

You can do a simple join query without using the JOIN keyword by specifying the two tables in the FROM clause and establishing a relationship in the where clause.

For example

   SELECT columns
   FROM table1, table2
   WHERE table1.field = table2.field

answered Jul 9, 2013 at 3:29

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

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

Comments

Robert DeBoer · Accepted Answer · 2013-07-09 03:20:55Z

1

You are asking about SQL Joins, the practicing of putting two or more tables together in an SQL statement to return data from more than 1 table. You join the tables on a common column, such as author.authorid = book.authorid. I suggest looking up JOINS on google, there are many good articles.

A great article on it: http://www.sitepoint.com/understanding-sql-joins-mysql-database/

answered Jul 9, 2013 at 3:20

Robert DeBoer

1,6952 gold badges16 silver badges26 bronze badges

Comments

Matt Bryant · Accepted Answer · 2013-07-09 03:22:10Z

1

It sounds like you are looking for a join. Try something like the following:

SELECT * FROM tb_columnas JOIN tb_autores ON tb_columnas = col_Autor WHERE col_Status='activo' ORDER BY col_ID DESC

answered Jul 9, 2013 at 3:22

Matt Bryant

4,9714 gold badges33 silver badges46 bronze badges

Comments

Sumoanand · Accepted Answer · 2013-07-09 03:23:06Z

1

You need to understand joins for this.

Here you will find very good explanation of the same:

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

answered Jul 9, 2013 at 3:23

Sumoanand

8,9293 gold badges50 silver badges46 bronze badges

Collectives™ on Stack Overflow

Mysql Query with two tables php

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related