Re: Updating or Inserting a database from a txt file

[Animator]

in reply to Updating or Inserting a database from a txt file

Usless post: read at your own risk.

I should have know this node would get up-voted and front-paged...

Noone cares that this is the third time that the OP asks the same question, right?

Even when in the previous nodes working code (and good code) was suggested, clearly the OP decides not to use it and use yet another approach... Why is the biggest question I guess...

[mlh2003]

I didn't see the previous post :(
Otherwise I probably would have said something similar...

[NodeReaper]

This node was taken out by the NodeReaper on Tue May 10 11:27:55 2005 (EST)
Reason: [ktross]: Deleate: duplicate of Re^2: Updating or Inserting a database from a txt file

For more information on this node visit: this

[Nik]

Whats your problem?
You never help, either on irc, neither here, all you do is just complain,kickban people and nothing more.
I will try as many ways as a like to make it work and i dont give a damn if you like it or not, neither i care if you help or not.

[DaWolf]

Actually the OP's previous posts seem different from this one. Previously he was looking for answers and now he's looking for improvements.

Have I missed something?

Nik, please be polite. Rudeness will only make things worse.

Hope you find your answers.

Regards,

[Nik]

Sorry man, i got carried away there but i become mad with the both of them and especially Animator on irc.
Yes iam trying to improve the script as you correctly noticed.

I changed it again. Here it is now:

my (@row, $gamename, $gamedesc, $gamecount);
my $select = $dbh->prepare( "SELECT * FROM games WHERE gamename=$gamen
+ame" );
my $insert = $dbh->prepare( "INSERT INTO games (gamename, gamedesc, ga
+mecounter) VALUES (?, ?, ?)" );
my $update = $dbh->prepare( "UPDATE games SET gamedesc=?, gamecount=?+
+1 where gamename=?" );

open (FILE, "<../data/games/descriptions.txt") or die $!;
    while (<FILE>) {
        chomp;

        ($gamename, $gamedesc) = split /\t/;
        $select->execute( $gamename );

        if ($select->rows) {
           $update->execute( $gamedesc, $gamecount, $gamename );
        }
        else {
           $insert->execute( $gamename, $gamedesc, 0 );
        }
    }
close (FILE);

the descriptions.txt contains a blank line after each line of info. I dont want it to be loaded and also every time games.pl is runnign it gets doubled and doubles each time!

Anyone can see why?

[Nik]

Whats your problem? You never help, either on irc, neither here, all you do is just complain,kickban people and nothing more. I will try as many ways as a like to make it work and i dont give a damn if you like it or not, neither i care if you help or not.

[Nik]

Hey, sorry that was accidentally posted.