// $sql="SELECT * FROM T_NEWS Where Respost=1 ". $txt ." order by Data DESC ";
$sql="SELECT * FROM T_NEWS Where Id_NEW > 0 ". $txt ." order by Respost DESC , Data DESC ";
$query=mysql_query($sql);
$num_rows=mysql_numrows($query);
for ($i=0;$i<$num_rows; $i++) {
if (( mysql_result($query,$i,Respost)==1) || ($superuser > 0) ) { // escriu dades si respost o superusuari
?>
| · |
$color="black";
if (mysql_result($query,$i,Respost)==0 ) { $color="RED";}
?>
>
echo mysql_result($query,$i,Consulta) ; ?>
( echo mysql_result($query,$i,Data); ?> )
|
if ($superuser > 0) {
echo " ";
if (mysql_result($query,$i,Respost)==0 ) { echo "No Publicar ";}
else { echo "Publicar";}
echo " Edición \n ";
echo " | ";
}
?>
| |
>
echo mysql_result($query, $i ,Resposta) ; ?>
|
|
| |
>
$doc=mysql_result($query, $i , Email);
if (strlen($doc)>5)
{
$traduccion = array(" " => "%20");
$link= strtr($doc,$traduccion);
// echo "";
echo " ";
echo " Documento: ". $doc ." " ;
echo " \n";
}
?>
|
|
}
}
?>
|