include ('pages/dbconnect.php');            
    $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC");
    echo "<table class='gridtable'>";
    echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>";
    echo "</tr>";
    echo "</tr>";
    $odl_dept = null;
    $odl_com = null;
    $odl_org = null;

            //List of department
                echo "<td>".$dep['dept']."</td>";
            //display blank td if the same department is found a second time
            else{echo "<td></td>";}   
            //List of commune
                echo "<td>".$dep['com']."</td>";
            //display blank td if the same commune is found a second time
            else{echo "<td></td>";}   
    // list of organizations
                echo "<td>".$dep['nom']."</td>";
                $org= $dep['nom'];
                //display the number of animal for each organization
                $qcab= mysql_query("SELECT sum(`qte_an`) FROM `t_animal` WHERE ((org= '$org') AND (nom_an='Cabrit'))") or die(mysql_error());
                $arr_cab = mysql_fetch_array($qcab);
                $qte_cab = $arr_cab[0];
                echo "<td>"; echo $qte_cab; echo "</td>";
    echo "</tr>";        
    $odl_dept = $dep['dept'] ;
    $odl_com = $dep['com'] ;
    $odl_org = $dep['nom'] ;
echo "</table>";

Edited by Belton

3 Years
Discussion Span
Last Post by mglobs

Hi everyone, i ask for your help because that's the first time i have to export it, after reading some comment and some document, i' able to export data from one table but this case is different, i combine different tables in the query. is there any easiest way to get the data in order to export them. please me...


Take a moment to read what you are asking and then read in wikipedia (or anywhere) what is html and what is excel. So the problem is producing the html table or do you really want to export your data to excel file ? .

Recently I learned that learning curve can be quite flat to people that are smart , but have no real interest to learn something new.


You could create a temporary table (using PHP) to combine the data from the other tables and then export that using PHPMyAdmin. You can also create a report putting the data into an HTML table and then write that to excel (if you want to avoid the manual intervention).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.