[ERROR]MySQL: mysql_num_rows

[!]

Code Select Expand

function PWebStats( player )
{
local myquery = mysql_query( MyDB,"SELECT Name FROM Account WHERE Name='"+player.Name+"'");
if ( mysql_num_rows( myquery ) == 0 )
{
mysql_query( MyDB, "INSERT INTO Account( *** ) VALUES( *** )" );
print("inserted");
}
else if ( mysql_num_rows( myquery ) > 0 )
{
mysql_query( MyDB, "UPDATE Account SET( *** ) VALUES( *** );
print("Updated");
}
mysql_free_result( myquery );
}

By using this function it works first time but next time it throw an error

[spoiler]

Code Select Expand

AN ERROR HAS OCCURED [Error in 'mysql_num_rows': Wrong number of arguments or invalid argument type]

CALLSTACK
*FUNCTION [PWebStats()] scripts/Functions.nut line [9]

LOCALS
[myquery] false
[sqlquery] USERPOINTER
[player] INSTANCE
[this] TABLE
[r] USERPOINTER
[e] USERPOINTER
[w] USERPOINTER
[q] USERPOINTER
[player] INSTANCE
[this] TABLE
[det] 439300
[cash] 439400
[amount] 100
[player] INSTANCE
[this] TABLE
[reason] 70
[player] INSTANCE
[this] TABLE[/spoiler]

The mysql query is false.
Is this because of poor connection or something else.

[Cool]

Line 9 == ?

Code Select Expand

  mysql_query( MyDB, "INSERT INTO Account( *** ) VALUES( *** )" ); what is this? only *** Does Account have colum Named ***

[!]

Line 9 == ?

Code Select Expand

  mysql_query( MyDB, "INSERT INTO Account( *** ) VALUES( *** )" ); what is this? only *** Does Account have colum Named ***

It means other shits
Name, User, Kills, Deaths
ets
And in values their values

[Thijn]

Why not use else? It's not going to be less then zero, so if it's not exactly zero it's automatically bigger then that.

[!]

Why not use else? It's not going to be less then zero, so if it's not exactly zero it's automatically bigger then that.

Ok but what about error on line 4

Code Select Expand

if ( mysql_num_rows( myquery ) == 0 )

[EK.IceFlake]

If a MySQL query returns false, there is an error with it. You can use my plugin to detect MySQL errors.

[KAKAN]

there is a sqlquery in your locals too

[!]

If a MySQL query returns false, there is an error with it. You can use my plugin to detect MySQL errors.

I'll try.

there is a sqlquery in your locals too

Yup, Locals

[!]

Bump
Is there any method to find error why query is false
In official mysql plugin.
Anyone

[EK.IceFlake]

print(mysql_error(mysql instance));
This is how my plugin's MySQL error reporting works.

Code Select Expand

        local r = ::mysql_query(inst, q), err = ::mysql_error(inst);
        if (::mysql_error(inst) != "") throw err;By the way, I just noticed that I don't need that variable there.