query($query); $separator = ""; if ($conn->next_record()) { $entityName = $conn->field_value("SI_ENTITY_NAME"); $firstName = $conn->field_value("SI_FIRST_NAME"); $lastName = $conn->field_value("SI_LAST_NAME"); $streetName = $conn->field_value("SI_STREET_NAME"); $streetNumber = $conn->field_value("SI_STREET_NUMBER"); $locality = $conn->field_value("SI_LOCALITY"); $postalCode = $conn->field_value("SI_POST_CODE"); $country = $conn->field_value("SI_CONTRY"); $fixedPhone = $conn->field_value("SI_FIXED_PHONE"); $mobile = $conn->field_value("SI_MOBILE"); $fax = $conn->field_value("SI_FAX"); $email = $conn->field_value("SI_EMAIL"); $web = $conn->field_value("SI_WEB"); $entityNameStatus = $conn->field_value("SI_ENTITY_NAME_STATUS"); $contactPersonStatus = $conn->field_value("SI_CONTACT_PERSON_STATUS"); $adressStatus = $conn->field_value("SI_ADRESS_STATUS"); $phoneFaxStatus = $conn->field_value("SI_PHONE_FAX_STATUS"); $emailWebStatus = $conn->field_value("SI_EMAIL_WEB_STATUS"); } print "&ENTITYNAME=".utf8_encode($entityName); print "&FIRSTNAME=".utf8_encode($firstName); print "&LASTNAME=".utf8_encode($lastName); print "&STREETNAME=".utf8_encode($streetName); print "&STREETNUMBER=".utf8_encode($streetNumber); print "&LOCALITY=".utf8_encode($locality); print "&POSTALCODE=".utf8_encode($postalCode); print "&COUNTRY=".utf8_encode($country); print "&FIXEDPHONE=".utf8_encode($fixedPhone); print "&MOBILE=".utf8_encode($mobile); print "&FAX=".utf8_encode($fax); print "&EMAIL=".utf8_encode($email); print "&WEB=".utf8_encode($web); print "&ENTITYNAMESTATUS=".$entityNameStatus; print "&CONTACTPERSONSTATUS=".$contactPersonStatus; print "&ADRESSSTATUS=".$adressStatus; print "&PHONEFAXSTATUS=".$phoneFaxStatus; print "&EMAILWEBSTATUS=".$emailWebStatus; ?>