03.05.2010, 15:30
@PawnNewCommer,
1. Ah what a fail, you need to format query. You can also use that array 'query' instead of 'result' now, so you don't need to open new 128 cells big one.
2. It should be like this:
------------------------
@AlecRae,
I think this would work
1. Ah what a fail, you need to format query. You can also use that array 'query' instead of 'result' now, so you don't need to open new 128 cells big one.
Код:
new query[128]; mysql_real_escape_string(password,password); format(query,sizeof(query),"SELECT * FROM players WHERE id=%d AND password='%s' LIMIT 1",PlayerInfo[playerid][pSQLID],password); mysql_query(query); ...
Код:
mysql_fetch_field_row(PlayerInfo[playerid][pMarriedTo],"MarriedTo");
@AlecRae,
I think this would work
Код:
SELECT Name,PhoneNumber FROM players WHERE Name LIKE '%%%s%%'