arrays - PHP Array_Unique Problem -

-

i don't know php well, please bear me.

my client has database information , 1 of fields ff_date_time in format "tue oct 5 14:43:10 2010". there lot of entries in here , need display list of days have entries: ie,

  • tue oct 5, 2010
  • thurs oct 7, 2010
, on. there may hundreds of entries on day, when pull in dates db need go through , extract right data , filter it. here's have far:

$query = "select ff_date_time booth_submit";  $query_result = mysql_query($query); $datetimes = array(); $dates = array();  while ($row = mysql_fetch_array($query_result)) {   $datetimes[] = $row['ff_date_time']; }  ($i = 0; $i < sizeof($datetimes); $i++) {   $temp = explode(" ", $datetimes[$i]);   $dates[] = ($temp[0]." ".$temp[1]." ".$temp[2]." ".$temp[4]);  # breaks date_time 'mon oct 5 2010' format }  $dates = array_unique($dates);                       ($i = 0; $i < sizeof($dates); $i++) {   echo('<a href="#">'.$dates[$i].'</a><br />');  }

i'm doing similar thing 2 others fields work fine, reason, yields $dates array right length (ie: 4 unique dates, array size 4), first $dates element has info. output looks this:

<a href="#">mon oct 3 2010</a><br /> <a href="#"></a><br /> <a href="#"></a><br /> <a href="#"></a><br />

when don't use array_unique , test values check if getting loaded , parsed correctly, array should ("mon oct 3 2010","mon oct 3 2010","mon oct 3 2010","mon oct 4 2010","mon oct 5 2010","mon oct 5 2010","mon oct 6 2010").

any clues what's going wrong here?

assign unique array array variable. , use foreach.

$newarr = array(); $newarr = array_unique($dates); foreach ($newarr $date) {   echo('<a href="#">'.$date.'</a><br />' . "\n");  }

Comments

Post a Comment

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

-
basically i've got update query runs when click submit button. i have asp:repeater in page layer inside this <asp:repeater id="dgbookings" runat="server" onitemdatabound="itemdb"> <itemtemplate> <div class="bookingscontent"> <div class="bookingdetails" id="<%# databinder.eval(container.dataitem, "booking_ref") %>"> <p class="infotext"><%# databinder.eval(container.dataitem, "adults") %> <asp:linkbutton onclick="editdetails" text="edit..." runat="server"></asp:linkbutton></p> <p class="infotext"><asp:linkbutton onclick="submitdetails" text="submit..." runat="server"></asp:linkbutton></p> </div> </div> </itemtemplate> <asp:repeater> and outputs ...
Read more

jquery - appear modal windows bottom -

-
i have modal windows in application, work fine <div id="modal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="mymodallabel" aria-hidden="true"> but when modal appears, appear top of windows, , want appear bottom the application joomla 3.0! , using template of meet gavern any idea? i found solution i modified de css in bootstrap .modal.fade { top:-25%; -webkit-transition:opacity .3s linear, bottom .3s ease-out; -moz-transition:opacity .3s linear, bottom .3s ease-out; -ms-transition:opacity .3s linear, bottom .3s ease-out; -o-transition:opacity .3s linear, bottom .3s ease-out; transition:opacity .3s linear, bottom .3s ease-out; }
Read more

c++ - Compiling static TagLib 1.6.3 libraries for Windows -

-
i having super hard time compiling , using taglib 1.6.3 in qt project. i've tried can think of. taglib claims supported through cmake i'm not having luck. furthermore, i'm confused kinds of files need qt libs! i've built *.a files, *.lib, , *.dll. understand far... believe since i'm working in windows *.lib want. no matter do, end "undefined references" taglib functions try use when try compile qt project. have tried mingw32, msys, visual studio 2008, , cross-compiling windows on linux. turning nothing. what makes less sense me if compile same taglib source qt on mac (g++ think?) works fine! somewhere in windows compilation procedures have going wrong. have been smacking face on desk 30 (on , off) hours trying figure out. since qt uses mingw must compile taglib same compiler? if compile *.lib's visual studio not compatible? are *.a libraries usable in windows? (assuming mingw) i'm still trying handle on c++ stuff, after reading coun...
Read more