How can I obtain the number of news entries based on the number defined in the smarty template?

How can I obtain the number of news entries based on the number defined in the smarty template? I just got started with the smarty template and want to control the number of news items displayed in the template. the following shows 5 news items:

 
 

  
  {section name=news loop=$arr max=5}
  
  
{$arr[news].title}
{/section}
 
 

In the php program, how does one read the corresponding number of records based on the number of entries in the template? How to obtain the number of entries set in the template?
To implement the following SQL:

SELECT id, title, wdate FROM news ORDER BY id DESC LIMIT 0, 5

Instead:

SELECT id, title, wdate FROM news ORDER BY id DESC

Reply to discussion (solution)

Is it up to you to decide how many items you want? Just write it directly... limit 0, 5

$ Smarty. section. loop. index is missing. The number of items currently running can be determined.

$ Smarty. section. sectionname. index either. Determine the number of rows from 1 to 5. Otherwise, do not run. Search by the landlord to find out

 
 

  
  {section name=news loop=$arr max=5}    
  
  
{$arr[news].title}
{/section}
 
 

Sorry, I didn't understand. I mean, how can I get the max = 5 defined in the template in php?

Define another variable and introduce

Define another variable and introduce
Can it be more specific? I just got in touch and don't know how to define it.

The cycle of smarty can be controlled and terminated, but it should not be yours.

No interest in smarty!

I know, it's not like this. Generally, the display template is called only after the data is ready.