[saamp]

I have a database with 10 rows and 30 fields. I want to go on each row, and to get the fieldName 'pName' and to print it. Is there any efficient function rather that this?

Код:

	mysql_query("SELECT `pName` FROM `database`");
	mysql_store_result();

	new registeredPlayers = mysql_num_rows();

	if(registeredPlayers)
	{
		new pName[MAX_PLAYER_NAME];
		while(mysql_retrieve_row())
		{
			mysql_get_field("playerName", pName);
			printf("%s", pName);
		}
	}

	mysql_free_result();

	printf("Total registered players: %d", registeredPlayers);

[Sinner]

Quote:

Originally Posted by saamp I have a database with 10 rows and 30 fields. I want to go on each row, and to get the fieldName 'pName' and to print it. Is there any efficient function rather that this? Код: mysql_query("SELECT `pName` FROM `database`"); mysql_store_result(); new registeredPlayers = mysql_num_rows(); if(registeredPlayers) { new pName[MAX_PLAYER_NAME]; while(mysql_retrieve_row()) { mysql_get_field("playerName", pName); printf("%s", pName); } } mysql_free_result(); printf("Total registered players: %d", registeredPlayers);

Use the latest MySQL plugin? Threaded queries are a lot more efficient.

[saamp]

Quote:

Originally Posted by Sinner Use the latest MySQL plugin? Threaded queries are a lot more efficient.

Yes, I think! Could you show me an example?

[Sinner]

https://sampforum.blast.hk/showthread.php?tid=337810