How can I

keespost · #1 (**permalink**) 09-06-11, 10:48

Hi,

I've got the following query:

Code:

SELECT b.*, a.* FROM books b LEFT JOIN authors a ON b.autor_id = b.id

Is it possible to get all columns from the table authors with a prefix? So I can see in my php code from what table the field is comming?

I want something like this:

Code:

SELECT b.*, a.* as author+nameOfTheColumn FROM books b LEFT JOIN authors a ON b.autor_id = b.id

---
Forgot to change the title, but now I cannot change it anymore?

it-iss.com · #2 (**permalink**) 09-06-11, 13:38

I am not too sure what you are asking for here? If you do something like:

Code:

SELECT b.*, a.author FROM books b LEFT JOIN authors a ON b.autor_id = b.id

Then in PHP

Code:

while($row = mysql_fetch_assoc($res)) {
  $row['author'] contains the information from the author field
}

bchanan · #3 (**permalink**) 09-07-11, 02:41

More east way to select specific fields from both tables, and use alias
(assuming you are not altering the tables structure often)

example:
create table kuku1(f1 int, f2 int);
create table kuku2(f1 int, f2 int);

select kuku1.f1 as kuku1_f1,
kuku1.f2 as kuku1_f2,
kuku2.f1 as kuku2_f1,
kuku2.f2 as kuku2_f2
from kuku1,
kuku2
where kuku1.f1 = kuku2.f1

Internet Services

Web Development

Digital Marketing

Consumer Tech