mysql group by help - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql group by help (
/showthread.php?tid=387734)
mysql help -
ombre - 26.10.2012
resolve
Re : mysql group by help -
ombre - 26.10.2012
just on THREAD_jobc how to show the result as on PHPmyadmin?
Re : mysql group by help -
ombre - 27.10.2012
I need to use mysql_num_fields mysql_field_count ? I use MySQL Plugin
Re : mysql group by help -
guesto - 28.10.2012
Код:
case THREAD_jobc:
{
if(IsPlayerConnected(extraid))
{
mysql_store_result();
new result[25];
while(mysql_retrieve_row())
{
new idjob;//,SQL;
mysql_fetch_field_row(result,"Job"); idjob = strval(result);
format(string, sizeof(string), "Job: %d: %d ", idjob, mysql_num_rows());
SendClientMessage(extraid, COLOR_WHITE, string);
}
}
mysql_free_result();
}
For the count I don't kwow