my $variable = "12,23,34";
my $variable = "'12','23','34'";
my $variable = "['12','23','34']";
my $variable = "(12,23,34)";
my $variable = "('12','23','34')";

I tried all of them for that:

my $all_db = $DB->table('Links');

$all_db->select_options ("ORDER BY Contact_Name", "");

my $sth = $all_db->select ( ['ID','Title','aLogo','Contact_Name','Hits'],
GT::SQL::Condition->new (
ID => IN => $variable
) );
while (my ($id,$title,$logo,$name,$hits) = $sth->fetchrow_array) {
...

I stuck with passing IDs to this SQL. Anyone here with help, please?

Ok. I have forgotten to watch GT´s Code.
I just use an array to pass. :)

ID => IN => /@variable

Yup, or:


BTW, make sure you use \ and not / as in your example

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!