$shippingAddress['LastName'] = $txtShippingLastName; $shippingAddress['Address1'] = $txtShippingAddress1; $shippingAddress['Address2'] = $txtShippingAddress2; $shippingAddress['City'] = $txtShippingCity; $shippingAddress['ZIP'] = $txtShippingZIP; $shippingAddress['FAX'] = $txtShippingFAX; $shippingAddress['Phone'] = $txtShippingPhone; $shippingAddress['Country'] = $ddlShippingCountry; $shippingAddress['State'] = $txtShippingState; $shippingAddress['Email'] = $txtShippingEmail; // Get data ends if (isset($_SESSION['guest_login']) && $_SESSION['guest_login'] == 1) { if ($_SESSION["sess_guest_login_id"] == "") { // Check email id alredy exist // Delete Cart Items which already exists $userid = clsUser::checkUserEmail($txtBillingEmail); if ($userid > 0) { $userid = clsUser::emptyCartForGuest(session_id(), $userid); } else { // Register user $userstring = strtolower(substr($txtBillingFirstName, 0, 3)); $get_username = generateUsername(6, 2); if ($userstring != '') { $username = $userstring . $get_username; } $guest_password = generatePassword(6, 2); $sql = "INSERT INTO " . $tableprefix . "users (\n\t\t\t\t\t\t\tuser_name,\n\t\t\t\t\t\t\tpassword,\n\t\t\t\t\t\t\tfirst_name,\n\t\t\t\t\t\t\tlast_name,\n\t\t\t\t\t\t\taddress1,\n\t\t\t\t\t\t\taddress2,\n\t\t\t\t\t\t\tcity,\n\t\t\t\t\t\t\tstate,\n\t\t\t\t\t\t\tcountry,\n\t\t\t\t\t\t\tphone,\n\t\t\t\t\t\t\tfax,\n\t\t\t\t\t\t\tzip,\n\t\t\t\t\t\t\temail,\n\t\t\t\t\t\t\tdate_registered\n\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($username) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string(md5($guest_password)) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingFirstName) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingLastName) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingAddress1) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingAddress2) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingCity) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingState) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($ddlBillingCountry) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingPhone) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingFAX) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingZIP) . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($txtBillingEmail) . "',\n\t\t\t\t\t\t\tnow()\n\t\t\t\t\t\t\t)"; mysql_query($sql) or die(mysql_error()); $userId = mysql_insert_id(); //insert shipping address if ($chkSaveShippingAddress == 1) {