Thanks Adam but actually i have quit tryign to do it with my way and i decided to do it with your way since it is more straighforward and less lines of code: Now the code is like this:
#=======================LOADING THE .TXT TO THE DATABASE==============
+==========
my $replace = $dbh->prepare( "REPLACE INTO games (gamename, gamedesc,
+gamecounter) VALUES (?, ?, ?)" );
open (FILE, "<../data/games/descriptions.txt") or die $!;
while (<FILE>) {
chomp;
if (length) {
$replace->execute( split(/\t/, $_, 2), 0 ) or print $dbh->errs
+tr;
}
}
close (FILE);
But the records never get updated and if i delete a row on the txt file but the insertion of a new row or an edit of an existing one work ok :-)
Also after this code i ahve this:
if( param() )
{
$dbh->do( "UPDATE games SET gamecounter=gamecounter+1 WHERE gamena
+me='$gamename'" );
$dbh->do( "UPDATE guestlog SET passage='$gamename' WHERE host='$ho
+st'" );
$sth = $dbh->prepare( "SELECT * FROM games WHERE gamename=?" );
$sth->execute( $gamename );
$row = $sth->fetchrow_hashref;
print span( {class=>'lime'}, "Είσαι ο $row->{gamecounter} ος πο
+υ κατεβάζει το $row->{gamename} !!" ), br;
print span( {class=>'yellow'}, "Ελπίζω να σου αρέσει και να σου φ
+ανεί χρήσιμο!" );
print p( {-align=>'center'}, a( {href=>'index.pl'}, img {src=>'.
+./data/images/back.gif'} ));
print "<script language='Javascript'>location.href=/data/games/$ga
+mename.rar</script>";
}
which is supposed to print a message when a user hits a game button to
+ be download and show the user what he choosed to downlaoded and how
+many time it was in general downloaded but it doesnt.