Raised This Month: $32 Target: $400
 8% 

How do I create this MySQL table?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
proffs
Senior Member
Join Date: Jul 2013
Old 07-22-2013 , 05:17   How do I create this MySQL table?
Reply With Quote #1

PHP Code:
formatex(szTemp,charsmax(szTemp), "SELECT (UNIX_TIMESTAMP(expire) - UNIX_TIMESTAMP()), expire FROM `hb_admin` WHERE `steamid` = '%s'"szSteamID
All i know the table has to be named hb_admin and 2 columns in it on expire and on steamid.
But where should i the expire date and how? and where do i enter the steam ID?

Last edited by proffs; 07-22-2013 at 05:36.
proffs is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 07-24-2013 , 09:09   Re: How do I create this MySQL table?
Reply With Quote #2

Seek assistance from your MySQL Manual to learn how to create the table
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 07-24-2013 , 11:15   Re: How do I create this MySQL table?
Reply With Quote #3

PHP Code:
CREATE TABLE IF NOT EXISTS `hb_admin` (`steamidVARCHAR(36PRIMARY KEY, `expireDATETIME); 
__________________
Impossible is Nothing
Sylwester is offline
Reply



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 07:15.


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