Scripting/Squirrel/Functions/mysql num rows

Returns the number of rows selected from a query.

Syntax

mysql_num_rows( query );

Arguments

• query - The name of the previously executed query.

Example

function onPlayerJoin()
{
local query<- mysql_query(vcmpdb, "SELECT * FROM bans WHERE IP = '"+player.IP+"'");
if (mysql_num_rows(query)==0)
{
ClientMessage("Welcome.",player,255,255,255);
}
else player.Kick();
}

Related Functions

• mysql_affected_rows
• mysql_change_user
• mysql_close
• mysql_connect
• mysql_errno
• mysql_error
• mysql_escape_string
• mysql_fetch_assoc
• mysql_fetch_lengths
• mysql_fetch_row
• mysql_free_result
• mysql_info
• mysql_insert_id
• mysql_num_fields
• mysql_num_rows
• mysql_ping
• mysql_query
• mysql_select_db
• mysql_warning_count