in reply to Re^2: Help with uni project: DBI errors in CGI script
in thread Help with uni project: DBI errors in CGI script

Well, first do what everyone has told you: change @results = $sth->fetchrow_array to @row = $sth->fetchrow_array. What I was suggesting by asking you if there was a param('Value') was that you should check in your script if something was entered in the field before attempting to query the database using the field. Yes, you have a field with that name in your form, but your script so far has no way to tell if the user put anything in that fields before clicking "submit".
  • Comment on Re^3: Help with uni project: DBI errors in CGI script

Replies are listed 'Best First'.
Re^4: Help with uni project: DBI errors in CGI script
by ginda (Initiate) on Mar 16, 2005 at 22:13 UTC
    So sorry 2 every1 and thanks at the sametime
    I left this code $sth->execute($sth); how it was when it should have been like $sth->execute();
    now its work fine :)