mysql datefield use datetime instead of datefield

Filed Under (Others) by admin on 22-12-2008

Assuming you just want a simple date field that just do dates, Use datetime its much safer it works as expected on both mysql 4 and 5 with no hassles, I mean it.

I noticed this on my project rentie at first I just show on my date timestamp as is (no formatting), that’s good but once i started formatting it errors came, I noticed this on mysql 4 timestamp is formatted like this 20080507083025 it means May 07, 2008 8:30:25 am, now in mysql 5 it formats like this 2008-05-07 08:30:25, pretty interesting huh!, thats why when i do my date formatting date goes way out, Now date time on mysql 4 and 5 will do this 2008-05-07 08:30:25 so its pretty solid it has the same format on both versions.

Lesson here just use datetime if you just need to display dates.

A google guide

Filed Under (Others) by admin on 21-12-2008

Yes it’s easy to use google just type the word you want to search then voila! results, google is ever improving their seach algo everyday as far as i know, just to make our everyday google search easier, but you can also refine your search better by using some google search techniques found at googleguides, this will make your search life easier.

The clones at mcdo

Filed Under (Others) by admin on 17-12-2008

Clones from the Pinoy501st Philippine Outpost taking orders from mc do customers, ok i got it so this what they do when they ran out of wars.
Man now I am that soooo geeky, I even have the guts to post this one.

gmail now with pdf viewer

Filed Under (Others) by admin on 17-12-2008


Finally a pdf viewer for gmail, this is great news and use so I can stop using the adobe bloatware reader no more, actually I stoped using it 2 years ago I am using foxit pdf right now. The advantage of having a pdf viewer in gmail is that you dont need to install pdf viewers anymore espcially the 30 mb adobe bloatware.

cut web development time

Filed Under (Others) by admin on 15-12-2008


SR or six revisions has posted a very informative article on how to cut web development time

I like the no. 10 entry which is to have less features, literally its the way to go start simple and keep it simple all the way

10. Have less features

You have to evaluate the need for certain web application features and if the time-investment of building in the feature is worth it. Do your users really need a custom RSS feeds for categories of an infrequently updated CMS? Do you really need to have a style switcher that detects where the user is geographically?

Make feature incorporation an uphill battle; features that don’t help the end-user in any way not only costs unneeded development time, but also complicates the interface.

read from 9-1 here

Easily create patterns with http://bgpatterns.com/

Filed Under (Others) by admin on 09-12-2008

create patterns like this one

its so easy try it now
http://bgpatterns.com

serving the best spaghetti code in town since 2005

Filed Under (Others) by admin on 05-12-2008

I like the katesgasis.com tagline

serving the best spaghetti code in town since 2005

I mean it’s cool sometimes to do spaghetti especially for small project you just want to get done and improve as you go along that’s cool kategasis is the creator of asides or some people call it sideblog the worpdpress plugin I will be using on my next site under itlivewire networks it will be called ukay, download sideblog here http://katesgasis.com/download-page.

jquery dynamically update table rows data

Filed Under (jquery) by admin on 01-12-2008

Tagged Under :

To dynamically change the table rows use this smart approach using jquery

Assign your new table data rows to a variable
var msg="<tr><td>Kristine</td><td>18</td><td>peach</td></tr><tr><td>Vanessa</td><td>25</td><td>strawberry</td></tr>";

Delete the exsiting rows except for the header tr:first – represents first row of the table – which happens to be our header
$("table tr:first").siblings().remove();

Then add the new data, the msg javascript variable used here holds the new table rows data
$("table tr:first").after(msg);

I have a very detailed step by step tutorial you can view here

ads
ads

Jobs at Lexmark Cebu

Software Tools Developer 5 Dec 2008, 1:11 pm

Software Tools Developer

Source: Jobs at Lexmark Jobs at Lexmark |

Company Nurse 5 Dec 2008, 1:11 pm

Company Nurse

Source: Jobs at Lexmark Jobs at Lexmark |

Industrial Designer 5 Dec 2008, 1:11 pm

Industrial Designer

Source: Jobs at Lexmark Jobs at Lexmark |

Data Owner 5 Dec 2008, 1:11 pm

Data Owner

Source: Jobs at Lexmark Jobs at Lexmark |

Firmware Product Systems Engineer (FPSE) 5 Dec 2008, 1:11 pm

Firmware Product Systems Engineer (FPSE)

Source: Jobs at Lexmark Jobs at Lexmark |

Talent Management Specialist 5 Dec 2008, 1:11 pm

Talent Management Specialist

Source: Jobs at Lexmark Jobs at Lexmark |

Business Control Analyst (Auditor) 5 Dec 2008, 1:11 pm

Business Control Analyst (Auditor)

Source: Jobs at Lexmark Jobs at Lexmark |

SAP System Analyst 5 Dec 2008, 1:11 pm

SAP System Analyst

Source: Jobs at Lexmark Jobs at Lexmark |

Firmware Development Engineers 5 Dec 2008, 1:11 pm

Firmware Development Engineers

Source: Jobs at Lexmark Jobs at Lexmark |

HR Officer (Shared Services) 5 Dec 2008, 1:11 pm

HR Officer (Shared Services)

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Writers 5 Dec 2008, 1:11 pm

Technical Writers

Source: Jobs at Lexmark Jobs at Lexmark |

Spanish-speaking Customer Service Representative 5 Dec 2008, 1:11 pm

Spanish-speaking Customer Service Representative

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Illustrator 5 Dec 2008, 1:11 pm

Technical Illustrator

Source: Jobs at Lexmark Jobs at Lexmark |

Recruitment Assistant 5 Dec 2008, 1:11 pm

Recruitment Assistant

Source: Jobs at Lexmark Jobs at Lexmark |

Team Lead 5 Dec 2008, 1:11 pm

Team Lead

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Support Representative 5 Dec 2008, 1:11 pm

Technical Support Representative

Source: Jobs at Lexmark Jobs at Lexmark |

Technical Trainer 5 Dec 2008, 1:11 pm

Technical Trainer

Source: Jobs at Lexmark Jobs at Lexmark |

Software Build and Library Administrator 5 Dec 2008, 1:11 pm

Software Build and Library Administrator

Source: Jobs at Lexmark Jobs at Lexmark |

Business Database Administrator 5 Dec 2008, 1:11 pm

Business Database Administrator

Source: Jobs at Lexmark Jobs at Lexmark |

EDI - Support Analyst 5 Dec 2008, 1:11 pm

EDI - Support Analyst

Source: Jobs at Lexmark Jobs at Lexmark |