Mysql select in multiple tables

mlucicom
Posts: 32

Mysql select in multiple tables

Hi! i have this database select query:

Code: Select all

// Interogare sql SELECT $sql = "SELECT `location`.`id` , `location`.`location` , `location`.`customer` , `area`.`id` , `area`.`area` , `area`.`id_principal` , `area_description`.`id` , `area_description`.`description` , `area_description`.`id_area` , `area_images`.`id` , `area_images`.`patch`, `area_images`.`id_area`, `section`.`id_principal` , `section`.`id_principal` , `section`.`area_id` ,`section`.`section` , `section_description`.`description` , `section_description`.`id_principal` , `section_images`.`patch` , `section_images`.`id_principal` FROM `location` , `area` , `area_images` , `area_description` , `section` , `section_description` , `section_images` where `location`.`id`= `area`.`id_principal` AND `area_description`.`id_area` = `area`.`id` AND `area_images`.`id_area` = `area`.`id` AND `section`.`id_principal` = `location`.`id` AND `section_description`.`id_principal` = `location`.`id` AND `section_images`.`id_principal` = `location`.`id` ";
But if i have multiple record with same id in section_images i get this in different results.

Admin
Hello
I didn't understand what results it is returned by that Select, and what result you want to get.

mlucicom
I solve this..but i have any other question
If i have two column with same name in two different table and i foreach all results from database how can i make difference beetween this>

Admin
You can add an Alias to the selected columns (with AS).

Code: Select all

$sql ="SELECT t1.id, t1.name AS namet1, t2.name AS namet2 FROM table1 AS t1, table2 AS t2";
- In php the results set will be with the name defined as alias. The array will have the keys: "id", "namet1", "namet2".
You can set any valid name as an alias.

Similar Topics