mysql while
#1

Hello, I want to load all messages that are stored in mysql, I use this:
Код:
format(query, sizeof(query), "SELECT Sender, Message, id FROM `messages` WHERE `Receiver` = '%s' AND `Read` ='0'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query, "|"))
{
new message[256], sender[MAX_PLAYER_NAME], id;
sscanf(query, "p<|>s[24]s[256]d", sender, message, id);
str_replace(sender, '_', ' ');
format(string, sizeof(string), ""COL_ORANGE"[O-PM] from %s:"COL_YELLOW" %s", sender, message);
SendSplitMessage(playerid, -1, string);
}
But this code only sends 1 message, what's wrong with it?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)