title: joomla mysql query with parameter like
body: <p>I want to bind the id of the content item table and link the menu table. I need to build the query as follows:</p>
  
  <pre><code>protected function getListQuery() 
  {
  
      $url="index.php?option=com_content&amp;view=article&amp;id=";
      // Create a new query object.
      $db = JFactory::getDBO();
      $query = $db-&gt;getQuery(true);
  
      // select the items
      $query-&gt;select('ar.id,ar.alias,ar.introtext,ar.images,ar.created,m.link,m.path');
  
      // of content table and menu table
      $query-&gt;from('#__content as ar, #__menu as m');
      $query-&gt;where('m.link like '+$url+'ar.id');
  
      $query-&gt;order('ar.id desc');
      return $query;
  }
  </code></pre>
  
  <p>The query returns 0 results. I need to attach the <code>$url</code> parameter and <code>ar.id</code> to generate me find the full url.</p>
  
  <p>What I want you to show me a list of menu items in the table are linked to the parameter.
  for example:</p>
  
  <pre><code>index.php?option=com_content&amp;view=article&amp;id=70
  </code></pre>
  
  <p>Thanks!</p>