Auto Formating Array with subsc

Chadian22

I am trying to make a script that takes my blog entry dates, anlyze them, strip off the year, and the months and then make links, so then when a blog carriest on to a new month, i dont have to make a link for old posts, etc.. so this is what i have so far,


mysql_connect(filteredout... this is not the problem)
mysql_select_db("blog");
$query = "select date from blog";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
   while ($yearstripped = substr($row['date'],0,1,2,3)){
    	while ($monthstripped = substr($row['date'], 5,6)){
             if ($monthstripped == 01) { $month = "january" ; }
             if ($monthstripped == 02) { $month = "february" ; }
             if ($monthstripped == 03) { $month = "march" ; }
             if ($monthstripped == 04) { $month = "april" ; }
             if ($monthstripped == 05) { $month = "may" ; }
             if ($monthstripped == 06) { $month = "june" ; }
             if ($monthstripped == 07) { $month = "july" ; }
             if ($monthstripped == 08) { $month = "august" ; }
             if ($monthstripped == 09) { $month = "september" ; }
             if ($monthstripped == 10) { $month = "october" ; }
             if ($monthstripped == 11) { $month = "november" ; }
             if ($monthstripped == 12) { $month = "december" ; }
             print $row['date'];

the errors i get are : Warning: Wrong parameter count for substr() in C:\FoxServ\www\includes\test.php on line 11 < repeated for every blog post i have. If someone has a better idea of how to do this then speak up, because right now mine has to check every single post for a date change...

Shrike

First up, substr() only accepts 3 parameters:

string substr ( string string, int start [, int length])

Secondly, if you have a date field in your database, why not make use of the MySQL date or datetime types, and store your dates in a standard format, or store each date as a timestamp (which you can get when inserting the row using the mktime() or similar functions). You may then make use of PHP's excellent date manipulation functions like date() and strtotime(), which make your life alot easier, and code alot shorter.

There are lots of examples on this board, I can go into more detail if you like.

Chadian22

Dates are stored like this :
2004-05-03
Is that the right format for PHP's date manipulation

Shrike

Yes that's fine. PHP manipulates dates as timestamps, so you can either convert your date with PHP's functions(strtotime(), mktime() etc) or do it during the MySQL query, with MySQL's UNIX_TIMESTAMP function (if supported).

There's lots of useful examples at www.php.net.

Chadian22

Hmmm. I've been working a bit more on it, but i already store my dates by using PHP thing, now i need it select from certain months, but i need it to detect the avaliable months first...