Advertisement
Guest User

listar.php

a guest
Nov 22nd, 2018
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.40 KB | None | 0 0
  1. <?php
  2. $DB_HOST='localhost';
  3. $DB_USER='root';
  4. $DB_PASS='fatec';
  5. $DB='pessoas';
  6. $TB='dados_pessoais';
  7.  
  8. mysql_connect($DB_HOST, $DB_USER, $DB_PASS);
  9. mysql_select_db($DB);
  10. $query="SELECT DISTINCT * FROM $TB WHERE idade > 0 ORDER BY idade DESC";
  11. $resultado = mysql_query($query);
  12.  
  13. while($linha = mysql_fetch_array($resultado)){
  14.   echo "Nome: $linha[0]<br>Idade: $linha[1]";
  15.   echo "<hr>";
  16. }
  17.  
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement