Simple check for SELECT query empty result

SELECT * FROM service s WHERE s.service_id = ?;
IF @@rowcount = 0
begin
select 'no data'
end

`SELECT count(*) as CountThis ....`

Then you can compare it as string like so:

IF CHECKROW_RS("CountThis")="0" THEN ...

`CHECKROW_RS` is an object

well there is a way to do it a little more code but really effective

<!-- begin snippet: js hide: false console: true babel: false -->

<!-- language: lang-html -->

$sql = "SELECT * FROM messages"; //your query
$result=$connvar->query($sql); //$connvar is the connection variable
$flag=0;
while($rows2=mysqli_fetch_assoc($result2))
{ $flag++;}

if($flag==0){no rows selected;}
else{
echo $flag." "."rows are selected"
}

<!-- end snippet -->