sql_affectedrows or sql_numrows ?

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>";


      }

registered · 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.