vc²Ù×÷mysql³ö´í! - VC/MFC / ÍøÂç±à³Ì

Ϊʲô»á´íÎó?? »¹ÓÐlike '%ÕâÀïÈçºÎÌæ»»%' ? 
MYSQL_RES *res;
MYSQL_ROW row;
CString str;
CString str1;
char sql[255];
memset(sql,0,sizeof(sql));
((CComboBox*)GetDlgItem(IDC_Com_category))->GetWindowText(str1); //ÕâÀï»ñÈ¡CComboBoxÑ¡ÔñµÄÖµ
sprintf(sql,"select id,name from `category` where name like '%'%s'%' and parent_id=0 order by order_list desc",str1);
mysql_query(&mysql,sql);
if (!(res=mysql_use_result(&mysql)))
{
MessageBox("¶ÁÈ¡Êý¾Ý¿â¼¯Ê§°Ü");

}
int i = 0;
while (row = mysql_fetch_row(res))
{
str.Format("%s",row[0]);

MessageBox(str);
}

mysql_free_result(res);

---

¿ÉÒÔÁË Ð»ÁË