1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| /* On lance la requête... */
query = malloc(256+user->lg);
sprintf(query,"SELECT bug_id FROM bugs b, users u WHERE b.affecte_a = u.user_id AND b.status = 2 AND u.login = '%s';",user->buf);
TRACE1("TestFTwithUsername, REQ MySQL : %s\n",query);
if (mysql_query(sock,query))
{
char *tmp;
TRACE2("TestFTwithUsername : Couldn't select to mysql (%s)\n %s\n",mysql_error(mysql),query);
tmp = "E fwcvs: Couldn't find FT in the database.\n";
envoiebuf(CLNTOUTPUT,tmp,strlen(tmp));
free(query);
mysql_close(mysql);
return 0;
}
else
{
res = mysql_store_result(sock);
row = mysql_fetch_row(res);
int nblignes = mysql_num_rows(res);
TRACE1("NB Lignes : %d\n", nblignes);
for(j = 0; j < nblignes; j++)
{
sprintf(str,"%s", row[j]);
TRACE1("STR : %s\n",str);
}
} |
Partager