Working on some mysql query today, some of the tips through my work
- in stead of using the old school method join the 2 table ( the one select field from 2 table, where x value on table A = y value on table B) , use the inner join better ,it seem like more efficient and the results are more accurate.
- if doing query base on date range, example x is a date field, x between fromdate and todate, the fromdate and todate need enclose with single quote like this ‘fromdate’ and ‘todate’.
- date range query using between , the todate need to add 1 more day.
- date_format is one of the useful function to convert the date field display in the format you want
Tips
mysql
When i try to port over this google chrome theme for habari, i know *nothing8 about habari theme structure. That’s why my first stop is Habari Wiki.
Follow the article Creating a Custom Theme , but i keep getting error when i try to activate my custom theme, what’s wrong ? i been follow step by step on the wiki yet i m still stuck.
After doing comparison with some of the theme, i find out that one thing has been missing from the wiki, for the theme.xml , it is a must to include description, this is a new theme should be added in theme.xml.
if you just like me a newbie to habari and having some problem when create new theme, check it out did you include description for your theme ?
Tips
habari
This actually allow you posting from subform, iframe or pop up windows. Lets say you have a pop up registration form and you need it to post to submit page for regisration process and when the process done, it will redirect to thankyou page.
In order to avoid the posting action only happen in the pop up windows, what you can do is adding target to parent, so that it will post from the pop up form to the parent site that calling this pop up form.
<form method="post" action="submit.php" target="parent">
Tips
form, pop up windows, subform