Posts archive for July, 2012

Maximum length for MySQL TEXT field types

advertisement

mysqlJust gone thru the maximum length limit for different MySQL TEXT field types. I’m designing a table to store large amount of data within a field. To avoid data being truncated automatically, it’s good to know the maximum length limit for different MySQL TEXT field types.

Here’s the summary for maximum length limit for different MySQL TEXT field types:

Continue reading Maximum length for MySQL TEXT field types »

MySQL: Full text search for multiple words

advertisement

mysqlI notice one of my MySQL full text search result for multiple words doesnt seems correct. After some checking, i realize i don’t know how to do full text search for multiple words! LOL. This is because i use ONLY single words during testing. After go thru the MySQL documentation again, now i get a clear view of how to structure the SQL statement for full text search (multiple words)!

Here are some example for MySQL full text search for multiple words:-

Continue reading MySQL: Full text search for multiple words »

Easy to use jQuery Lightbox – Fancybox

advertisement

jqueryRecently I’m busy doing an appointment booking system and i need to use JavaScript lightbox in some section. As u know there are plenty of jQuery lightbox plugin around, and i need to choose the most stable and easy to use lightbox plugin for my system. After some testing, i find that Fancybox suit my need and it’s so easy to use, of course it’s flexible too.

To implement this Fancybox jQuery lightbox plugin, you just need to include 3 files:-

Continue reading Easy to use jQuery Lightbox – Fancybox »