Join 2 SQL tables and display in 1 PHP Table

Question

I want to join 2 SQL tables with same attribute but different data and display in 1 PHP Table. Table w2 and w3 and display in 1 PHP table. I am new to PHP so the Code might be very wrong.

    <?php  
    //create database connection 

    require_once('C:\Users\TO115956\Documents\EasyPHP-DevServer-14.1VC11\data\localweb\projects\...\db_w2.php'); 
    require_once('C:\Users\TO115956\Documents\EasyPHP-DevServer-14.1VC11\data\localweb\projects\...\db_w3.php'); 

    //query the db 
    $query = mysqli_query($connect ,"SELECT Avis,Cde_Sap,Don_Ordre,PN_in ,SN_in,DATE2,Statut_Cde FROM w2 , w3") ;
    ?>
    <table>
    <tbody>
    <?php

    while($w2= mysqli_fetch_assoc($query)){
    echo"<tr>";

    echo"<td>".$w2['Avis']."</td>";
    echo"<td>".$w2['Cde_Sap']."</td>";
    echo"<td>".$w2['PN_in']."</td>";
    echo"<td>".$w2['SN_in']."</td>";
    echo"<td>".$w2['DATE2']."</td>";
    echo"<td>".$w2['Statut_Cde']."</td>";
    //  echo"<td>".$w2['Employee']."</td>";
    //  echo"<td>".$w2['Comment']."</td>";

}//end while 
        while($w3= mysqli_fetch_assoc($query)){
    echo"<tr>";

    echo"<td>".$w3['Avis']."</td>";
    echo"<td>".$w3['Cde_Sap']."</td>";
    echo"<td>".$w3['PN_in']."</td>";
    echo"<td>".$w3['SN_in']."</td>";
    echo"<td>".$w3['DATE2']."</td>";
    echo"<td>".$w3['Statut_Cde']."</td>";
//  echo"<td>".$w3['Employee']."</td>";
//  echo"<td>".$w3['Comment']."</td>";
}//end while 
?>
<tbody>
</table>

I want to display both the SQL tables in 1 PHP table.

The SQL statement will result in a cross join all records related to all records. Is this really what you want or do you want to do a JOIN so that only related records are matched together? Regardless when the query executes this will generate one result set. You shouldn't have to iterate though each table separately. Query to database returns result set . You process the result set in Php To display the data. Since a result set combines the tables for you already, all you should have to do is reference the result set and columns desired to be displayed. — xQbert
– xQbert, Commented Apr 27, 2015 at 13:47
Thanks for your help @xQbert . It is almost similar to situation of displaying all the data of my both the tables but the data does not have any connection . They only have the same table attributes . Suggest what to do now . Thank you in advance . — Anuraag Kapoor
– Anuraag Kapoor, Commented Apr 27, 2015 at 13:54
If you can provide more information about the two tables then we can see how it can be done — ramsai
– ramsai, Commented Apr 27, 2015 at 14:01
instead of a JOIN cross /join use a UNION statement. SELECT Avis,Cde_Sap,Don_Ordre,PN_in ,SN_in,DATE2,Statut_Cde FROM w2 UNION ALL SELECT Avis,Cde_Sap,Don_Ordre,PN_in ,SN_in,DATE2,Statut_Cde FROM w3 UNION if you want to eliminate duplicates. Union All if you want to keep duplicates. — xQbert
– xQbert, Commented Apr 27, 2015 at 14:01

xQbert · Accepted Answer · 2015-04-27 14:14:35Z

1

Use a union. I don't think you want a cross join here given desired results and comments...

SELECT Avis,Cde_Sap,Don_Ordre,PN_in ,SN_in,DATE2,Statut_Cde 
FROM w2 
UNION ALL 
SELECT Avis,Cde_Sap,Don_Ordre,PN_in ,SN_in,DATE2,Statut_Cde 
FROM w3

answered Apr 27, 2015 at 14:14

xQbert

35.5k2 gold badges46 silver badges67 bronze badges

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

Comments

Disturb · Accepted Answer · 2015-04-27 14:41:06Z

0

I would recomend you to use an inner join (or left or right join) and if you are concerned about performance try using temporary tables.

answered Apr 27, 2015 at 14:41

Disturb

5988 silver badges15 bronze badges

Collectives™ on Stack Overflow

Join 2 SQL tables and display in 1 PHP Table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related