Guest User

Untitled

a guest
Jul 11th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost';
  3. $dbuser = 'city2';
  4. $dbpass = 'city123'';
  5.  
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  7.  
  8. $dbname = 'citywide2';
  9. mysql_select_db($dbname);
  10.  
  11.  
  12. //The first query will pull all buildings by the owner.
  13. $query = "SELECT * FROM buildings WHERE buildings.ownerid = $variable_in_URL"
  14.  
  15. $result = mysql_query($query) or die(mysql_error());
  16.  
  17.  
  18. $row = mysql_fetch_array($result) or die(mysql_error());
  19. echo $row['address']. " - ". $row['closeintersect'];
Add Comment
Please, Sign In to add comment