Can someone see the problem here, cause i cant
08-03-05, 01:13 AM
Newbie Coder
Join Date: Oct 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Can someone see the problem here, cause i cant
Okay in the next little bit of code, All of it works, but when it gets to the point of formatting the sql table name for August it outputs 08 instead of Aug... basically it takes an input of teh numerical month .. 01, 02, 03 etc etc, and then formats it to the abbreviated alpha month, Jan, Feb, Mar and then it creates a MySQL table in the format of Jan_2005... I dont understand why it returns all teh other months correctly except for August.. when i look at it everthing looks correct.. Maybe someone else can see a mistake im missing... FYI this isnt the complete script, i can provide it if need be...
PHP Code:
################################################################################
function points_table ( $player , $month , $day , $time , $venue , $tpr , $place , $rank , $bonus , $total ) {
$year = date ( "Y" );
$table = " $year " . '_' . 'points' ;
connect_to_mysql ();
$bpoints = bonus_point ( $place , $tpr );
$rpoints = rank_point ( $place );
$total = $rpoints + $bpoints ;
$month_formatted = format_month_table ( $month );
$monthly_table = " $month_formatted " . '_' . " $year " ;
mysql_query ( "CREATE TABLE IF NOT EXISTS ` $monthly_table ` (`id` int(20) NOT NULL auto_increment,`name` varchar(40) NOT NULL default '',`month` varchar(20) NOT NULL default '',`day` varchar(20) NOT NULL default '',`year` int(4) NOT NULL default '0',`time` varchar(5) NOT NULL default '',`venue` varchar(40) NOT NULL default '',`tplayer` int(20) NOT NULL default '0',`place` int(20) NOT NULL default '0',`rank` int(20) NOT NULL default '0',`bonus` int(20) NOT NULL default '0',`total` int(20) NOT NULL default '0',PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=6 " ))
mysql_query ( "INSERT INTO ` $monthly_table ` VALUES ('',' $player ',' $month ',' $day ',' $year ',' $time ',' $venue ',' $tpr ',' $place ',' $rpoints ',' $bpoints ',' $total ')" );
"New Monthly Table Added To Database" ;
mysql_query ( "INSERT INTO ` $monthly_table ` VALUES ('',' $player ',' $month ',' $day ',' $year ',' $time ',' $venue ',' $tpr ',' $place ',' $rpoints ',' $bpoints ',' $total ')" );
mysql_query ( "INSERT INTO ' $table ' VALUES ('',' $player ',' $month ',' $day ',' $year ',' $time ',' $venue ',' $tpr ',' $place ',' $rpoints ',' $bpoints ',' $total ')" );
mysql_close ();
################################################################################
function format_month_table ( $month ){
$month == 01 ) { $month = 'Jan' ; }
$month == 02 ) { $month = 'Feb' ; }
$month == 03 ) { $month = 'Mar' ; }
$month == 04 ) { $month = 'Apr' ; }
$month == 05 ) { $month = 'May' ; }
$month == 06 ) { $month = 'Jun' ; }
$month == 07 ) { $month = 'Jul' ; }
$month == 08 ) { $month = 'Aug' ; }
$month == 09 ) { $month = 'Sep' ; }
$month == 10 ) { $month = 'Oct' ; }
$month == 11 ) { $month = 'Nov' ; }
$month == 12 ) { $month = 'Dec' ; }
$month ;
################################################################################
function tndata_form (){
<form action=' $_SERVER [ PHP_SELF ] ' method='post'>
EOF;
################################################################################
Also some of this code isnt complete, i still have some work to do on it, but the basic code works that i need, ill clean the rest of it up after i figure out this problem, if not i may just say ta hell with it and have it outpiut the table name all numerically
Last edited by lppa2004; 08-03-05 at 01:15 AM .
08-03-05, 03:01 AM
Code Guru
Join Date: Oct 2004
Location: UK
Posts: 801
Thanks: 0
Thanked 0 Times in 0 Posts
try putting the numbers in quotes e.g.
elseif ($month ==
" 09
" ) { $month = 'Sep'; }
also if you look at
http://php.net/date you will see the character M in a date function gives "a short textual representation of a month, three letters"
__________________
Alexa Share <-- Trade virtual shares in websites with this online game.codR.us <-- Submit and vote for your favorite code snippets with codR.us.XEWeb.net <-- The ultimate PHP resource network.
08-03-05, 02:32 PM
Newbie Coder
Join Date: Oct 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
thanks that fixed it, still dont know why all the other months worked except for that one, kinda weird.. o well, it works now, thats all that matters... I thought about quoting them but since teh rest worked i didnt think it would make a difference.. lol
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes
Linear Mode
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
Linear Mode
