asked on
create FUNCTION [dbo].[TorahmatesByNameEmail]
(
@firstname nvarchar(50), @lastname nvarchar(50),@email nvarchar(100),@phone nvarchar(100)=NULL,@dob nvarchar(50) =NULL
)
RETURNS TABLE
AS
RETURN
(
SELECT CST_CSM_ID, ind_firstname, ind_lastname, ind_id , tel_id
FROM CST ......
try {
$nume = $conn->query("use admire; select count(ind_firstname) from [TorahmatesByNameEmail] ('xxx','xx','xxxxx',NULL,NULL)")->fetchColumn();
echo "<br>Number of records : ". $nume;
...