Changes between Version 8 and Version 9 of Docs/Prog/Manual/ApplicationLibraries/Database/MySQLclient

Timestamp:

02/04/13 09:41:23 (12 years ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/Database/MySQLclient

@@ -54 +54 @@
         }
 
-        //printf("query success\n");
-
         int rows_affected = (int) mysql_affected_rows(conn);
 
         printf("affected %d\n", rows_affected);
 
-        if(rows_affected < 1) // select, show
+        if(rows_affected < 1) // SELECT or SHOW will now have any rows affected, so display query results
         {
                 res = mysql_use_result(conn);
-                //printf("rows %d filuelds %d eof %d\n", res->row_count, res->field_count, res->eof);
-
                 int cnt = 0, i;
 
@@ -77 +73 @@
                                     if(i > 50)
                                         break;
-                                        printf("%s,", res->fields[i].name);
+
+                                    printf("%s,", res->fields[i].name);
                                 }
                                 printf("\n");
@@ -84 +81 @@
                         if(cnt > 10000)
                                 break;
-                        //printf("%d ", cnt);
+
                         for(i = 0; i < (int)res->field_count; i++)
                         {
@@ -90 +87 @@
                             if(i > 50)
                                 break;
-                                printf("%s,", row[i]);
+                            printf("%s,", row[i]);
                         }
                         printf("\n");