Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 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. {
  9. if (in_array($val, $arr)) {
  10. echo ' selected';
  11. }
  12. }
  13.  
  14. $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";
  15. $result = $mysqli->query($sql);
  16. while ($row = $result->fetch_assoc()) {
  17. echo "<option value=\"$row[sid]\"";
  18. isSelected('$row[sid]', $categories);
  19. echo ">$row[secao_nome]</option>";
  20. }
  21. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement