Ok, if I'm understanding your self - the easiest way would probably be to do it like this:
my $val = $DB->table('Links')->do_query('SELECT price FROM prices WHERE name = ?', @_[0] )->fetchrow;
my $val2 = $DB->table('Links')->do_query('SELECT pricesF FROM prices WHERE name = ?', $_[1])->fetchrow;
if ($val2) {
return $val2 ? $val2 : 'No price found';
}
return $val ? $val : 'No price found';
}..then call with:
Untested, but should work.
Cheers
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!
Code:
sub { my $val = $DB->table('Links')->do_query('SELECT price FROM prices WHERE name = ?', @_[0] )->fetchrow;
my $val2 = $DB->table('Links')->do_query('SELECT pricesF FROM prices WHERE name = ?', $_[1])->fetchrow;
if ($val2) {
return $val2 ? $val2 : 'No price found';
}
return $val ? $val : 'No price found';
}
Code:
<%if cardname1 or card1foil%><%get_value_prices($cardname1,$card1foil)%><br /><%endif%>Untested, but should work.
Cheers
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!