Raised This Month: $ Target: $400
 0% 

sql command


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
spyvingen
Junior Member
Join Date: Aug 2007
Old 08-27-2007 , 07:27   sql command
Reply With Quote #1

Hello i would like to have som help with an sql command.

This is my table :
Code:
id          int(10)      NO      PRI      NULL      auto_increment
steamid_killer     varchar(20)     YES           NULL      
steamid_victim     varchar(20)     YES           NULL      
weapon         varchar(15)     YES           NULL      
headshot     varchar(1)     YES           NULL      
killtime     datetime     YES           NULL
And as you see it ill be one line for each kill.
I would like an sql that reads out a list/array with how many kills, deaths and suisude every person have in the past week.

is it possible to make that in one sql command or do i have to make an sql for each value and player.

The thing is that if i have to make it with one sql/player then it would be 90 sql commands each visit and im guesing thats not so fun for the server

BR. Jonas
spyvingen 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 16:10.


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