Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. <?php
  2. $query = $mysqli->query("SELECT usuario_id, secao_id_cat FROM secao_usuarios WHERE usuario_id='$u[id]'");
  3. $dados = $query->fetch_assoc();
  4. $categories = explode(",",$dados['secao_id_cat']);
  5. //print_r($categories);
  6.  
  7. function isSelected($val, $arr){
  8. if(in_array($val, $arr)){
  9. echo ' selected';
  10. }
  11. }
  12. $sql = "SELECT sid, id_tipo_anun, secao_nome, amigavel, icone, tipo, secao_prod, status FROM secao WHERE tipo='cat' AND id_tipo_anun='3' AND secao_prod='sim' AND status='sim' AND destacar='sim' ORDER BY posicao ASC";
  13. $result = $mysqli->query($sql);
  14. while ($row = $result->fetch_assoc()) {
  15. echo "<option value=\"$row[sid]\""; isSelected('$row[sid]', $categories); echo ">$row[secao_nome]</option>";
  16. }
  17. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement