SA-MP Forums Archive
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