Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <select name="categories[]" id="example-getting-started"
- multiple="multiple" class="form-control">
- <?php
- $query = $mysqli->query("SELECT usuario_id, secao_id_cat FROM secao_usuarios WHERE usuario_id='$u[id]'");
- $dados = $query->fetch_assoc();
- $categories = explode(",", $dados['secao_id_cat']);
- //print_r($categories);
- function isSelected($val, $arr)
- {
- if (in_array($val, $arr)) {
- echo ' selected';
- }
- }
- $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";
- $result = $mysqli->query($sql);
- while ($row = $result->fetch_assoc()) {
- echo "<option value=\"$row[sid]\"";
- isSelected('$row[sid]', $categories);
- echo ">$row[secao_nome]</option>";
- }
- ?>
- </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement