pgsjoe Posted March 20, 2006 Share Posted March 20, 2006 I have this...[code] $m = $_GET['m'];if ($m == "") { $m = mktime(NULL, NULL, NULL, date('m'), 1, date('Y'));}$month = date("m", $m);$r = mysql_query("SELECT id, date FROM `calendar` WHERE date LIKE '%-$month-%'");while ($line = mysql_fetch_row($r)) { $days[$line[1]] = Array('#'.$line[0], 'linked-day');}print_r($days); [/code]which gives me this... (the #numbers are the ID numbers which I'm setting up as anchor links).[code]Array( [2006-03-30] => Array ( [0] => #7 [1] => linked-day ) [2006-03-16] => Array ( [0] => #10 [1] => linked-day ) [2006-03-01] => Array ( [0] => #19 [1] => linked-day ) [2006-03-15] => Array ( [0] => #21 [1] => linked-day ))[/code]All I need is just the day without leading zeros, like this...[code]Array( [30] => Array ( [0] => #7 [1] => linked-day ) [16] => Array ( [0] => #10 [1] => linked-day ) [1] => Array ( [0] => #19 [1] => linked-day ) [15] => Array ( [0] => #21 [1] => linked-day ))[/code]I tried this...[code] $days[substr($line[1],8)] = Array('#'.$line[0], 'linked-day');[/code]and got leading zeros on single digit days...[code]Array( [30] => Array ( [0] => #7 [1] => linked-day ) [16] => Array ( [0] => #10 [1] => linked-day ) [01] => Array ( [0] => #19 [1] => linked-day ) [15] => Array ( [0] => #21 [1] => linked-day ))[/code]but [b]I need single digit days to return as [i]1[/i] instead of [i]01[/i][/b].I also tried...[code] $days[date('j',$line[1])] = Array('#'.$line[0], 'linked-day');[/code] but got...[code]Array( [31] => Array ( [0] => #21 [1] => linked-day ))[/code]I'm completely out of options and need help!!! Quote Link to comment https://forums.phpfreaks.com/topic/5371-format-date-in-an-array/ Share on other sites More sharing options...
kenrbnsn Posted March 20, 2006 Share Posted March 20, 2006 You almost had it here:[code]<?php $days[date('j',$line[1])] = Array('#'.$line[0], 'linked-day'); ?>[/code]The date() function takes as it's second parameter an integer containing the number of second since 1-1-1970, so[code]<?php $days[date('j',strtotime($line[1]))] = Array('#'.$line[0], 'linked-day'); ?>[/code]should give you what you're looking for.Ken Quote Link to comment https://forums.phpfreaks.com/topic/5371-format-date-in-an-array/#findComment-19149 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.