Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1. <?php
  2. $connection = mysql_connect('localhost',"sernec","sernec");
  3. if(!$connection){ die('Not connected : '.mysql_error()); }
  4.  
  5. $db_selected = mysql_select_db("SERNEC",$connection);
  6. if(!$db_selected){  die('Cant use db: '.mysql_error()); }
  7.  
  8. $query = "SELECT * FROM SECountiesEntries";
  9. $result = mysql_query($query);
  10. if(!$result){
  11. die('Invalid query: ' .mysql_error());
  12. }
  13.  
  14. while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
  15. {
  16. echo $row['state_name'] . ",";
  17. echo $row['county_name'] . ",";
  18. echo $row['fips'] . ",";
  19. echo $row['count'] . ",";
  20. echo $row['entries'] . ",";
  21. echo $row['category'] . ",";
  22. echo $row['latlng'] . "\n";
  23. }
  24. mysql_close($connection);
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement