Database

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Usp_Add_AddressCommunication]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
/****************************************************************************************************/
/* NAME     : [Usp_Add_AddressCommunication]                                                                        /
/ PURPOSE  : THIS STORED PROCEDURE Addes address communication /
/ TABLES USED:                                                                                         /
/                  [dbo].[CommunicationTypeLKP]    , AddressCommunication  , Address                                                           /
<h2>/ VERSION HISTORY:-                                                                                    */</h2>

<h2>/* VERSION NUMBER|  DATE        |   AUTHOR                  |   CHANGES                                 */</h2>

/* 1.0           |  09/19/2017  |   aaleti              |   INITIAL VERSION                         */

<hr />

ALTER PROCEDURE [dbo].[Usp_Add_AddressCommunication] 
(

    @AddressId int,
    @CommunicationType varchar(60),
    @CommunicationValue varchar(60),
    @CreatedBy varchar(30)

)

AS
BEGIN
DECLARE @CommTypeId int
SET @CommTypeId = (Select top 1 CT.PKCommunicationTypeLKPId from CommunicationTypeLKP CT where CT.CommunicationTypeDesc = @CommunicationType)

         INSERT INTO [dbo].[AddressCommunication]
           ([FKAddressId]
           ,[FKCommunicationTypeLKPId]
           ,[CommunicationValue]
           ,[ValidFlag]
           ,[CreatedDate]
           ,[CreatedBy]
           ,[ModifiedDate]
           ,[ModifiedBy]
           )
     VALUES
           (@AddressId
           ,@CommTypeId
           ,@CommunicationValue
           ,1
           ,getdate()
           ,@CreatedBy
           ,getdate()
           ,@CreatedBy)
            select SCOPE_IDENTITY() as PkAddrCommId

END
' 
END

$id = 47;
echo 'current id is:'.$id;
//GET PREVIOUS ID
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id<$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Previous ID is:'.$row['article_id'];
//GET NEXT ID
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id>$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Next ID is:'.$row['article_id'];

current id is:47
Previous ID is:24
Next ID is:48