Squirrel/Server/Functions/MySQL/mysql num rows

Latest revision as of 11:26, 17 October 2012

[edit] Syntax

mysql_num_rows( result )

[edit] Returns

Number of results found, to the query.

[edit] Example

local c = mysql_connect( "host", "user", "pass", "db" );
local q = format( "SELECT * FROM tbl_name WHERE name = '%s'", player.Name );
local r = mysql_query( c, r );
if( mysql_num_rows( r ) ! = 0 ) // If there is a result
{
}
else // No result found
{
}
mysql_free_result( r );
mysql_close( c );