PHP need help

Im working in a webpage that we can store news, and i have a code that creates a word file with three tables with data from database, the problem is that i want them ordered by a specific order. The code is above.

[php]<?php
include(“auth.php”); //include auth.php file on all secure pages
require(‘db.php’);
error_reporting(0);
if(isset($_POST[‘chk’])=="")
{
?>

<?php
}
$chk = $_POST[‘chk’];
$chkcount = count($chk);
?>

table {border-collapse: collapse;width: 100%; font-family:calibri;padding: 5px;} th{border: 1px solid black;font-size:24px;font-weight:normal;padding: 2px;} td{border: 1px solid black;} tr{font-family:calibri;} [member=6119]Page[/member] Section1{margin: 0.5cm 0.5cm 0.5cm 0.5cm;} div.Section1 { page:Section1;}

Análise Diária de Noticias <?php setlocale(LC_TIME,"portuguese"); echo strftime("%d de %B de %Y"); ?> Segurança & Defesa <?PHP HEADER("Content-Type: application/msword"); HEADER("Content-Disposition: attachment; filename=ADN.doc"); HEADER("Pragma: no-cache"); HEADER("Expires: 0"); for($i=0; $i<$chkcount; $i++){ $id = $chk[$i]; $res=$con->query("SELECT * FROM teste1 WHERE id='$id'"); while($row=$res->fetch_array()) { if ($row['categoria'] == 'Destaque'){ echo ""; echo "
Destaque
Género: ".$row['genero']." - ".$row['genero1'].""; echo "Título: ".$row['titulo'].""; echo "Fonte: ".$row['fonte'].""; echo "Resumo: ".$row['resumo']."

"; echo ""; }else if ($row['categoria'] == 'Criminalidade'){ echo ""; echo "
Criminalidade
Género: ".$row['genero']." - ".$row['genero1'].""; echo "Título: ".$row['titulo'].""; echo "Fonte: ".$row['fonte'].""; echo "Resumo: ".$row['resumo']."

"; echo ""; }else{ echo ""; echo "
Gerais
Género: ".$row['genero']." - ".$row['genero1'].""; echo "Título: ".$row['titulo'].""; echo "Fonte: ".$row['fonte'].""; echo "Resumo: ".$row['resumo']."
"; echo ""; }}} ?>
[/php]

use an order by in your sql

Sponsor our Newsletter | Privacy Policy | Terms of Service