Opa, muito obrigado por responder.
no caso o query está assim :
$query="SELECT * FROM folders WHERE id IN ('".$folders."') ORDER BY name ASC";
dai devo colocar assim :
$query="SELECT * FROM folders WHERE id IN ('".$folders."') ORDER BY name ASC != 'papel'";
Obrigado.
O script está assim:
if($level!="user"){
$upload_dirs="";
$query="SELECT * FROM folders ORDER BY name ASC";
$result=mysql_query($query) or die("error getting folders from database"); while($rr=mysql_fetch_assoc($result)){
$upload_dirs .= "<option value='".$rr["name"]."' ".($upload_dir==$rr["name"]?"selected":"").">".$rr["name"]."</option>";
}
} else {
/*
$q="SELECT upload_dirs FROM users WHERE id='".$_SESSION["idUser"]."'";
$res=mysql_query($q);
$rr=mysql_fetch_assoc($res);
$folders = str_replace(',',"','",$rr["upload_dirs"]);
$query="SELECT * FROM folders WHERE id IN ('".$folders."') ORDER BY name ASC";
$result=mysql_query($query) or die("error getting folders from database"); while($rr=mysql_fetch_assoc($result)){
$upload_dirs .= "<option value='".$rr["name"]."' ".($upload_dir==$rr["name"]?"selected":"").">".$rr["name"]."</option>";
} */
if(!stristr($access,"i")){ //if user cant see all files
$q="SELECT upload_dirs FROM users WHERE id='".$_SESSION["idUser"]."'";
$res=mysql_query($q);
$rr=mysql_fetch_assoc($res);
$folders = str_replace(',',"','",$rr["upload_dirs"]);
$query="SELECT * FROM folders WHERE id IN ('".$folders."') ORDER BY name ASC";
$result=mysql_query($query) or die("error getting folders from database"); while($rr=mysql_fetch_assoc($result)){
$upload_dirs .= "<option value='".$rr["name"]."' ".($upload_dir==$rr["id"]?"selected":"").">".$rr["name"]."</option>";
}
} else {
$query="SELECT * FROM folders ORDER BY name ASC";
$result=mysql_query($query) or die("error getting folders from database"); while($rr=mysql_fetch_assoc($result)){
$upload_dirs .= "<option value='".$rr["name"]."' ".($upload_dir==$rr["id"]?"selected":"").">".$rr["name"]."</option>";
}
}
}