sql_affectedrows or sql_numrows ?

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I have code inserting questions into a table from a txt file.

I wanted to capture how many records were written.

sql_numrows was not working. sql_afffectedrows seems to be but I am only getting a count of 1 when the test.txt file has 10 questions.

Could this be as simple as ...

Quote:

A total of $i question was successfully written to the database!

Code:

for ($i=1; $i < count($quiz_ques); $i++)
{

   $sql = "INSERT INTO questions (cat_id, course_id, ques_name, stem, choice1, choice2, choice3, choice4, choice5, points, feedback, createdby, lastedited_by, lastedited_date, source, qtype) VALUES (".$ca.", ".$cid.", '".$quiz_ques[$i][0]."', '".mysql_real_escape_string($quiz_ques[$i][1])."', '".mysql_real_escape_string($quiz_ques[ $i][4][0][0])."', '".mysql_real_escape_string($quiz_ques[ $i][4][0][1])."', '".mysql_real_escape_string($quiz_ques[ $i][4][0][2])."', '".mysql_real_escape_string($quiz_ques[ $i][4][0][3])."', '".mysql_real_escape_string($quiz_ques[ $i][4][0][4])."', '".mysql_real_escape_string($quiz_ques[$i][3])."', '".mysql_real_escape_string($quiz_ques[$i][2])."', 2, 2, ".time().", 'respondus', '1') ";
   $result = $db->sql_query($sql);
}

$count_import = $db->sql_affectedrows($result);
   if (!$result) {
   echo("<p>Error performing query: " . mysql_error() . "</p>");
   exit();
   }else{
      echo "A total of $count_import question was successfully written to the database! <br>";
   }

Gremmie · Posted: Thu Jul 24, 2008 12:41 pm

You are looping. Therefore you are always going to get 1 (if it was successful). You need to count inside the loop and display the result outside the loop.