Hello
How can I get specific ads with the advertising ID number?
Here you can fetch ads within a specific city
<?php osc_query_item("region_name=Madrid");
if( osc_count_custom_items() == 0) { ?>I want a specific advertisement with the ID number

Thanks

I found the solution
for the benefit

osc_query_item("id=145");

there is a problem
I want to fetch more than one ad with a specific number of ID
I did that but it is not responding
osc_query_item("id=145,146,250,266");

I would try:
osc_query_item("id in (145,146,250,266)");

If does not work, its probably not supported.

I would try:

Code: [Select]

osc_query_item("id in (145,146,250,266)");

If does not work, its probably not supported.

Unfortunately it doesn't work
Is there a solution for that?

No using osc_query_item, you can try Search model instead for more options and custom conditions.

No using osc_query_item, you can try Search model instead for more options and custom conditions.

Thank you general search problem
I have a custom page I want to fetch specific ads
Fixed for this page
Is there another way or by function
Thank you

Yes, search model.

Sample:
  $randSearch = Search::newInstance();
  $randSearch->dao->select(DB_TABLE_PREFIX.'t_item.* ');
  $randSearch->dao->from( DB_TABLE_PREFIX.'t_item use index (PRIMARY)' );
  $randSearch->dao->orderBy(DB_TABLE_PREFIX.'t_item.dt_pub_date DESC');
  $rs = $randSearch->dao->get();

  if($rs === false){
    return array();
  }

  if( $rs->numRows() == 0 ) {
    return array();
  }

  $items = $rs->result();
  $items = Item::newInstance()->extendData($items);


General search problem
I wish there was more explanation
 

Has any of you seen this problem?
please help

please help

Yes, search model.

Sample:

Code: [Select]

  $randSearch = Search::newInstance();
  $randSearch->dao->select(DB_TABLE_PREFIX.'t_item.* ');
  $randSearch->dao->from( DB_TABLE_PREFIX.'t_item use index (PRIMARY)' );
  $randSearch->dao->orderBy(DB_TABLE_PREFIX.'t_item.dt_pub_date DESC');
  $rs = $randSearch->dao->get();

  if($rs === false){
    return array();
  }

  if( $rs->numRows() == 0 ) {
    return array();
  }

  $items = $rs->result();
  $items = Item::newInstance()->extendData($items);


Completely ignored.
Go to that class and identify all supported methods.

Quote from: MB Themes on July 19, 2022, 09:42:33 AM

Yes, search model.

Sample:

Code: [Select]

  $randSearch = Search::newInstance();
  $randSearch->dao->select(DB_TABLE_PREFIX.'t_item.* ');
  $randSearch->dao->from( DB_TABLE_PREFIX.'t_item use index (PRIMARY)' );
  $randSearch->dao->orderBy(DB_TABLE_PREFIX.'t_item.dt_pub_date DESC');
  $rs = $randSearch->dao->get();

  if($rs === false){
    return array();
  }

  if( $rs->numRows() == 0 ) {
    return array();
  }

  $items = $rs->result();
  $items = Item::newInstance()->extendData($items);


Completely ignored.
Go to that class and identify all supported methods.

Sorry, I have poor coding experience
Can you help me, thank you

You have almost complete code there that require just to change one line with your condition.
If you are not able to utilize that, you should hire developer.