Raised This Month: $ Target: $400
 0% 

Register in the SQL if not already there?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
JCobra
Senior Member
Join Date: Mar 2006
Location: Canada
Old 01-21-2007 , 18:48   Re: Register in the SQL if not already there?
Reply With Quote #4

Example from harbu's plugins (first thing to come to mind involving mysql and amxx )

Code:
format(query,255,"INSERT INTO jobs (JobID,JobName,Salary,Access) VALUES('%i','%s','%i','%s')",JobID,title,p_salary,JobRight)

"jobs" would be the table
"JobID" column,
"JobName" column,
"Salary" column
"Access" column
And then you just need to put %i for the amount of columns each database has, then define what you're putting in by listing them in the same order as you inserted them into the tables
__________________
User has abandoned this account.
JCobra is offline
Send a message via AIM to JCobra
 



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 22:19.


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