Re: Looping almost the same repetitive lines



Nikos wrote:


$st = $db->prepare( "SELECT * FROM counter" );
you need to check the return value of this.

What happens when you execute this statement directly within the db
console? (mysql in this case) Do you get any results?

$st->execute();
and checj the return value of this.

$row = $st->fetchrow_hashref;

@tableRows = ();

while( $item = $st->fetchrow_hashref()) {
    push @tableRows, $item;
};

What happens when you use Data::Dumper to display @tablerows? Is it empty? If so, you have an issue with your query.




print table( {class=>'info'},
    map {
         Tr(
            td( submit( -name=>'game', -value=>$_->{name} )),
            td( $_->{text} ),
            td( $_->{name} )
            )
        } @tableRows
);

Whne i perl -c games.pl it says games.pl syntax OK from command line
Fine: it compiles. That doesn't tell us a lot. What happens when you *run* it?

when i view it from the broswer the only thing it displays is some other text above that code and nothing more. i t not evne designs the table.
You need to learn to partition your problem. What the browser displays is academic at this point; first of all you need to ascertain what the script is doing at what it outputs. You don't seem to know how to debug your programs.

You *need* to use strict. You *need* to use warnings. You *need* to use my. If you don't understand why, you need to read some more.

Mark
.



Relevant Pages

  • Re: [9fans] PUSH sources for Plan 9
    ... running push -r ... ... file descriptors are there. ... list is empty for both. ... echo hello |< cat>| cat ...
    (comp.os.plan9)
  • Re: Spurious Data returned from empty db column...
    ... when the record field contains an empty string, ... Apparently MySQL returns something ... different for an empty CHAR -vs- an empty VARCHAR. ... > Retrieving a 0-length string from a MySQL table column ...
    (alt.comp.lang.borland-delphi)
  • Re: Vector Sort Predicate Not Called
    ... "reserve" only reserve memory space to push al least PopSize elements in the ... but the vector is empty. ...
    (microsoft.public.vc.stl)
  • Re: Regular expression help
    ... I am trying to import entries in a csv file into a relational database, ... push @rec, ""; ... } elsif { ... Is this a commonly used method where you push empty values into an array ...
    (perl.beginners)
  • Re: [9fans] PUSH sources for Plan 9
    ... any instance of that string, ... echo hello |< cat>| cat ... rc (push): empty argument list ...
    (comp.os.plan9)