Raised This Month: $ Target: $400
 0% 

Mysql error.... have to escape?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
XyXEL
Junior Member
Join Date: Jun 2007
Old 06-06-2007 , 11:03   Mysql error.... have to escape?
Reply With Quote #1

this is the error in the log files
Quote:
L 06/06/2007 - 00:26:43: [AMXX] Plugin ("stats.amxx") is setting itself as failed.
L 06/06/2007 - 00:26:43: [AMXX] Plugin says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N^ 80^', kills='0', deaths='0'' at line 1
L 06/06/2007 - 00:26:43: [AMXX] Run time error 1 (plugin "stats.amxx") - forced exit
this is plugin code:
PHP Code:
Queries[1] = SQL_PrepareQuery(SqlConnection,"INSERT INTO steamids SET steamid='%s', name='%s', kills='0', deaths='0'",usersteam,clientname
well the problem seems to be the name, why does it cause the error? maybe it has to get escaped? how to escape it in Pawn ?
XyXEL is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:35.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode