Guest User

Untitled

a guest
Jan 16th, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.45 KB | None | 0 0
  1.  $result = mysql_query("SELECT * FROM tb_estados");
  2.       $cl = mysql_query("SELECT id FROM tb_estados WHERE uf IN (SELECT DISTINCT uf FROM tb_cidades ci JOIN tb_comarcas co ON ci.id = co.cidade)");
  3.       for($ests=array();$row = mysql_fetch_array($cl);$ests[]=$row["id"]);
  4.        while($row = mysql_fetch_array($result) ){
  5.             echo "<option value='".$row['id']."' " . (in_array($row["id"], $ests)?"class='cl'":"") . ">".$row['nome']."</option>";
Add Comment
Please, Sign In to add comment