hi i want to create module for k2 .
i want your help.
when i select from module id 1 from item to show title and fulltext from db.
i want to select multi id from admin e.g Select id : 1, 2

query is this _{$db = JFactory::getDbo();
$query = 'SELECT * FROM #__k2_items WHERE id ='.$params->get('id');
$db->setQuery($query);
$result = $db->LoadObjectList();
return $result;}

loop is this : ^{<div class="nameclas" style="width:200px;">
<?php foreach ($result as $row) :?>
<h1><?php echo $row->title; ?> </h1>
<?php endforeach ; ?>
</div> :(}

if i select id 1 from backend My returns the title one..
if i select id 1, 2 from backend i have this error... You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 SQL=SELECT * FROM d1l9y_k2_items WHERE id =1,2..... please help me... sorry for my english sucks :D

​Best regards,
Evanggelos E. Goritsas

Hi. Probably you need to read some SQL tutorials to learn how you can query with multiple keys. In general the IN function can be used dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in . You can always take a look at the code of mod_k2_content to get examples and ideas.

ty now is ok my module ty a lot!!

You are welcome.