#include <stdio.h>

#include <msql.h>

#define QUERY "SELECT * FROM CourseEnroll"

main(int argc, char *argv[])
{
  int dbSock, numRows, i ;
  m_result *myResults ;
  m_row myRow ;
  m_field *myField ;
  if ((dbSock= msqlConnect((char *)NULL))<0) {
    (void)fprintf(stdout, "Connection failure: %s\n", msqlErrMsg) ;
    exit(1) ;
  }
  if (msqlSelectDB(dbSock, "CSCI343")==-1) {
    (void)fprintf(stdout, "Can't select CSCI343: %s\n", msqlErrMsg) ;
    exit(1) ;
  }

  if ((numRows=msqlQuery(dbSock, QUERY))==-1) {
    (void)fprintf(stdout, "Query failed: %s\n", msqlErrMsg) ;
    exit(1) ;
  }

  (void)fprintf(stdout, "%d rows touched\n", numRows);

  myResults = msqlStoreResult() ;

  myField = msqlFetchField(myResults) ;
  i = 0 ;
  while (myField != NULL) {
    (void) fprintf(stdout, "Field %d -- %20s, %2d, %d\n",
		   i, myField->name, myField->length, myField->type) ;
    ++i ;
    myField = msqlFetchField(myResults) ;
  }

  for (i=0; i<numRows; ++i) {
    myRow = msqlFetchRow(myResults) ;
    (void) fprintf(stdout, "Row %d -- %s, %s, %s\n",
		   i, myRow[2], myRow[3], myRow[4] ) ;
  }

}