What is the condition for there are no results in the db?

[Jotade29]

Hi!!

My version is 2.0.19. Imagine that in the sources I have a file with a query (select name, description from files where id_member = {current_member}array...) I want to use this query in a context in a template, and I go through it with foreach

foreach ($context['query'] as $z)
here I would put the condition that if the member that queries this has no records, I get an error like: echo 'no records'... and in the else I would put all the records of that user.

What interests me is the if condition, I can think of putting 'if($z == "") or if(empty($z))... But it never shows me the echo of without records... But the else with the users who have records shows me fine. That makes me think that I am not hitting the condition so that I get that error when that user has no records. What would be the condition to put?

Thanks!!

[Kindred]

well....  if you are loading SMF files/data --  the variable $context is already used and filled with specific data.  Try using a different variable name.

[live627]

Code Select Expand

$request = $smcFunc['db_query']('', 'sql query here');

if ($smcFunc['db_num_rows']($request) == 0)
echo 'No results...'
Please provide your code as it will be easier for us to help you.