Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = 'localhost';
- $dbuser = 'city2';
- $dbpass = 'city123'';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- $dbname = 'citywide2';
- mysql_select_db($dbname);
- //The first query will pull all buildings by the owner.
- $query = "SELECT * FROM buildings WHERE buildings.ownerid = $variable_in_URL"
- $result = mysql_query($query) or die(mysql_error());
- $row = mysql_fetch_array($result) or die(mysql_error());
- echo $row['address']. " - ". $row['closeintersect'];
Add Comment
Please, Sign In to add comment