Gossamer Forum
Quote Reply
Only 2 fields selected?
I'm a little confused about this. I'm using the following codes, to try and grab the data from MySQL for links that has Reciprocal set to 1. I have the following;

Code:
my $table = $DB->table('Links');
my $sth = $table->select( Reciprocal => '1' );

while (my $hit = $sth->fetchrow_hashref) {

use Data::Dumper;
print Dumper($hit); exit;

}

I was having problems showing the $hit->{ID} and $hit->{Contact_Email} variables; so I investigated it more...and it seems to be down to GT::SQL not passing the right values back. The Data::Dumper call gives me;

$VAR1 = { '1' => '1', 'Reciprocal' => 'http://www.free-sex-online-casino.com' };

Anyone seen this before? I'm completly stumped....because to do this intentionaly, I thought you have to define which values you wanted to import?

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!
Subject Author Views Date
Thread Only 2 fields selected? Andy 1697 Apr 7, 2003, 4:28 AM
Thread Re: [Andy] Only 2 fields selected?
Paul 1594 Apr 7, 2003, 7:31 AM
Post Re: [Paul] Only 2 fields selected?
Andy 1605 Apr 7, 2003, 7:35 AM