[scott1]

Hi !

i am doing an sql system, so in an cmd, i need to cound number of players,

So i did

Код:

mysql_real_escape_string(inputtext, pseudosafe);
			format(query, sizeof(query), "SELECT COUNT(*) FROM `table_account` WHERE Nam LIKE '%%s%'",pseudosafe);

But the %%s% fucked up with the pseudosafe.

What can i do?

Max

[NewbBeginner]

Код:

mysql_real_escape_string(inputtext, pseudosafe);
			format(query, sizeof(query), "SELECT COUNT(*) FROM `table_account` WHERE Nam LIKE '%s'",pseudosafe);

[scott1]

No, i need %before and % after toget all result

[scott1]

http://www.1keydata.com/sql/sqllike.html

Quote:

SELECT * FROM Store_Information WHERE store_name LIKE '%AN%'

[Biesmen]

Never heard of that before.

[PeteShag]

Quote:

Originally Posted by scott1 No, i need %before and % after toget all result

No you don't since you've got only one variable.

Код:

pseudosafe

[Sergei]

Код:

"SELECT COUNT(*) FROM `table_account` WHERE Nam LIKE '%%%s%%'"

SAMP wiki is your friend next time, okay?

[scott1]

i need it for my query

like

%Max%

will give me

Maxwell_Nolin
Maxime_Norris
Julian_Maxvin

...

[scott1]

I found, simply Do %%%s%%