bolfescu 0 Junior Poster in Training

hy, unfor its not showing nothing...what it is wrong...?

<?php include('config.php'); error_reporting(0); ?>


 <table border=1>
    <tr>
        <td rowspan="3">Ditta</td>
        <td colspan="6">mandatori riceve</td>
        <td colspan="6">mandatori consegna</td>
        <td colspan="6">saldo</td>

    </tr>
    <tr>
        <td colspan="3">carelli</td>
         <td colspan="3"></td>
        <td colspan="3">carelli</td>
         <td colspan="3"></td>
        <td colspan="3">carelli</td>
    <td colspan="3"></td>
    </tr>
    <tr>
        <td>carrelli con piastra luc.rosso</td>
        <td>carrelli con piastra luc.nero</td>
        <td>carelli - senza piastra</td>
        <td>ripiani</td>
        <td>prolunghe</td>
        <td>doppie prolunghe</td>
        <td>carrelli con piastra luc.rosso</td>
        <td>carrelli con piastra luc.nero</td>
        <td>carelli - senza piastra</td>
        <td>ripiani</td>
        <td>prolunghe</td>
        <td>doppie prolunghe</td>
        <td>carrelli con piastra luc.rosso</td>
        <td>carrelli con piastra luc.nero</td>
        <td>carelli - senza piastra</td>
        <td>ripiani</td>
        <td>prolunghe</td>
        <td>doppie prolunghe</td>
    </tr>

    <?php

$sql = mysql_query("select date,category,sum(Carl) Total,sum(CarrelliCC) Total2,sum(Carrelli) Total3,sum(Ripiani) Total4,sum(Prolunghe) Total5,sum(DoppieProlunghe) Total6,sum(Carl2) Total7,sum(CarrelliCC2) Total8,sum(Carrelli2) Total9,sum(Ripiani2) Total10,sum(Prolunghe2) Total11,sum(DoppieProlunghe2) Total12,sum(q6) Total13,sum(q1) Total14,sum(q2) Total15,sum(q3) Total16,sum(q4) Total17,sum(q5) Total18 from articles WHERE category LIKE '" . mysql_escape_string($_POST['categor']) . "';");
while($row = mysql_fetch_array($sql))

{

    echo '<tr>';
    echo '<td>'.$row['category'].'</td>';
    echo '<td>'.$row['Total'].'</td>';
    echo '<td>'.$row['Total2'].'</td>';
    echo '<td>'.$row['Total3'].'</td>';
    echo '<td>'.$row['Total4'].'</td>';
    echo '<td>'.$row['Total5'].'</td>';
    echo '<td>'.$row['Total6'].'</td>';
    echo '<td>'.$row['Total7'].'</td>';
    echo '<td>'.$row['Total8'].'</td>';
    echo '<td>'.$row['Total9'].'</td>';
    echo '<td>'.$row['Total10'].'</td>';
    echo '<td>'.$row['Total11'].'</td>';
    echo '<td>'.$row['Total12'].'</td>';
    echo '<td>'.$row['Total13'].'</td>';
    echo '<td>'.$row['Total14'].'</td>';
    echo '<td>'.$row['Total15'].'</td>';
    echo '<td>'.$row['Total16'].'</td>';
    echo '<td>'.$row['Total17'].'</td>';
    echo '<td>'.$row['Total18'].'</td>';  
    echo '</tr>';

}

?>
    Ditta:
<select class="form-control" name="categor" id="categor"><?php $qry=mysql_query("SELECT * FROM category order by category ASC", $con);while($row=mysql_fetch_array($qry)){echo "<option value='".$row['category']."'>".$row['category']."</option>";}?></select></p>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
<input type="submit" name="submit" id="submit" class="btn btn-primary" value="Conferma" /></form>

</table>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.