Just 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.
Continue reading Maximum length for MySQL TEXT field types »
I 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)!
Continue reading MySQL: Full text search for multiple words »
Recently 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 »