$roomnumber=$DB_site->query_first("SELECT roomnumber FROM hotel WHERE roomname = '$roomname' AND roomkey = '$key'. To goto your room click <a href=".'"room.php?action=enterroom&roomnumber=$roomnumber&roomkey=$roomkey">here</a>');