title: Gives error DBD::mysql::st fetchrow_array failed: fetch() without execute() only for DELETE statement
body: <p>This isdb connection,</p>
  
  <pre><code>$DBH = DBI-&gt;connect("dbi:mysql:$DATABASE","$USER","$PASS",{ RaiseError =&gt; 1, AutoCommit =&gt; 1 }) or die "Connection Error: $DBI::errstr\n";
  </code></pre>
  
  <p>and the following code,</p>
  
  <pre><code>$sth=$DBH-&gt;prepare("DELETE FROM sample where id=1 ") or warn $DBH-&gt;errstr;
  $sth-&gt;execute or die "can't execute the query: $sth-&gt;errstr";
  while(@row = $sth-&gt;fetchrow_array()){
                  $count+=$sth-&gt;rows;
  }
  </code></pre>
  
  <p>The above code gives me error,</p>
  
  <blockquote>
    <p>DBD::mysql::st fetchrow_array failed: fetch() without execute()..</p>
  </blockquote>
  
  <p>But, when I use <code>select * from sample where id=1</code> then it runs. It gives me error only for <code>delete statement</code>. Why so?
  Help ! Thanx!</p>