Could someone please tell me the correct format for adding an OR clause to the WHERE part of the following query.
my $sth = $table->select (['fieldname'],{'fieldname' => $home->{cgi}->{fieldname}???? } );
I thought it should be something like the following but it doesn't work.
my $sth = $table->select (['fieldname'],{'fieldname' => $home->{cgi}->{fieldname}, 'OR', 'fieldname2' => $home->{cgi}->{fieldname2} } );
What should it be?
Thank you.
Simon.
my $sth = $table->select (['fieldname'],{'fieldname' => $home->{cgi}->{fieldname}???? } );
I thought it should be something like the following but it doesn't work.
my $sth = $table->select (['fieldname'],{'fieldname' => $home->{cgi}->{fieldname}, 'OR', 'fieldname2' => $home->{cgi}->{fieldname2} } );
What should it be?
Thank you.
Simon.