rendered paste body/////////////////// CURRENT
case 3:
printf("LIST ALL BALDE SERVERS ");
mysql_query(conn,"select count(0) from blade");
res = mysql_store_result (conn);
row = mysql_fetch_row (res);
printf("\nThere are %s blade server(s) in the database.. \n",row[0]);
printf("LISTING BLADE SERVER(S).... \n");
printf("NAME \t PMEM \t SMEM \t PORTS \t ARCH \ tSPEED \n");
while ( (row = mysql_fetch_result(res)) != NULL)
printf("%s \t %s \t %s \t %s \t %s \t %s \n",row[0],row[1],row[2],row[3],row[4],row[5]);
break;
///////////// WHAT YOU SHOULD BE DOING
case 3:
printf("LIST ALL BALDE SERVERS ");
mysql_query(conn,"select * from blade");
num_rows = mysql_num_rows(res);
printf("\nThere are %s blade server(s) in the database.. \n", num_rows);
printf("LISTING BLADE SERVER(S).... \n");
printf("NAME \t PMEM \t SMEM \t PORTS \t ARCH \ tSPEED \n");
while ( (row = mysql_fetch_result(res)) != NULL)
printf("%s \t %s \t %s \t %s \t %s \t %s \n",row[0],row[1],row[2],row[3],row[4],row[5]);
break;