clockwerk-www – Diff between revs 67 and 68

Subversion Repositories:
Rev:
Show entire file – Ignore whitespace
Rev 67 Rev 68
Line 56... Line 56...
56 } 56 }
57 } 57 }
58 try { 58 try {
59 $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD); 59 $mysql = new PDO('mysql:host='.$MYSQL_HOSTNAME.';dbname='.$MYSQL_DATABASE.';', $MYSQL_USERNAME, $MYSQL_PASSWORD);
60 $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 60 $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
61 $query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); 61 $query = $mysql->prepare("SELECT Name FROM land WHERE OwnerUUID=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)");
62 $query->bindParam(':first', $first); 62 $query->bindParam(':first', $first);
63 $query->bindParam(':last', $last); 63 $query->bindParam(':last', $last);
64 $query->execute(); 64 $query->execute();
65 } 65 }
66 catch(PDOException $e) { 66 catch(PDOException $e) {