그누보드 질문은 아니지만..

<a href="http://code7.tistory.com/7" target="_blank" rel="noopener noreferrer">http://code7.tistory.com/7</a>

<a href="http://blog.daum.net/_blog/BlogTypeView.do?blogid=0SsSt&articleno=218" target="_blank" rel="noopener noreferrer">http://blog.daum.net/_blog/BlogTypeView.do?blogid=0SsSt&articleno=218</a>

컨넥션은 위와같이하구요



쿼리문은 아래소스 참조해주세요



&nbsp; &nbsp; // 쿼리문을 보내기위한 함수

&nbsp; &nbsp; if (!mysql_query(&mysql,"SELECT * FROM Member_List"))

&nbsp; &nbsp; {

&nbsp; &nbsp; &nbsp; // 연결성공시 res에 결과를 받는다.

&nbsp; &nbsp; &nbsp; res = mysql_store_result(&mysql);

&nbsp; &nbsp; &nbsp; field_num = mysql_num_fields(res);

&nbsp; &nbsp; }

&nbsp; &nbsp; else

&nbsp; &nbsp; {

&nbsp; &nbsp; &nbsp; // 쿼리문 잘못 했을 시 에러메시지

&nbsp; &nbsp; }



&nbsp; &nbsp; // 결과를 얻어온다.

&nbsp; &nbsp; while((row = mysql_fetch_row(res)))

&nbsp; &nbsp; {

&nbsp; &nbsp; &nbsp; &nbsp; for (i=0 ; i < field_num; i++)

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; printf("%s&nbsp; ",row[i]);

&nbsp; &nbsp; &nbsp; &nbsp; printf("\n");

&nbsp; &nbsp; &nbsp; }



&nbsp; &nbsp; &nbsp; mysql_free_result(res);&nbsp; // res 메모리에서 해제

&nbsp; &nbsp; &nbsp; mysql_close(&mysql);&nbsp; // mysql을 닫는다.