case 2: printf("ENTER YOUR REQUIREMENTS : \n"); getdata(); sprintf (sql, "select * from blade where name=\"%s\"AND pmem=%d AND smem=%d AND ports=%d AND arch=\"%s\" AND speed=%d",name, pmem, smem,nports, arch, proc ); mysql_query(conn,sql); printf("THE FOLLOWING MATCH YOUR REQUIREMENTS : \n"); printf("NAME \t PMEM \t SMEM \t PORTS \t ARCH \t SPEED \n"); while ( (row = mysql_fetch_row(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;