Raised This Month: $ Target: $400
 0% 

DBI Query Help


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
nhdriver4
Senior Member
Join Date: Nov 2005
Old 04-08-2006 , 05:47   DBI Query Help
Reply With Quote #1

I was working with someone in the forums on using the correct syntax in my plugin, so that it's compatable with various database types.

This is the origional line that I used:
Code:
format(query, 350, "REPLACE INTO %s VALUES ( '%s','%s', '1' )", sql_table, authid, tag)

This is the line that I was told I should use. However, it doesn't update the database, or throw any error.
Code:
format(query, 350, "UPDATE %s SET steamid='%s', tag='%s', toggle='1'", sql_table, authid, tag)

Comments, or suggestions please?
__________________
nhdriver4 is offline
Send a message via AIM to nhdriver4
 



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 16:43.


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