_Problem #1_: How do I simplify my mySql where queries?
_Problem #2_: How can I search through an array in my where statement?
Answer: An awesome trick when it comes to querying multiple where clauses is to use the WHERE <…> IN command.
$id = ‘1,4,3,6,8,2′;
“SELECT * FROM <…> WHERE id IN ($id)”
Oh and did I mention you [...]
Help! I’d like to create a toolbar similar to facebook that is locked in the bottom of the screen.
Introduction Facebook is such a great website – usability, features, speed, you name it, facebook has it. One of facebook’s most useful feature is the toolbar that is being displayed to the bottom of the page. This [...]
One very important usability feature of a website is to have the menu or links highlight the current page the visitor is currently in. Here’s a trick I do with jquery to do just about that. For educational purposes, i’ve split it to 3 lines of code to make it more understandable.
Simply add the following [...]
Problem: Help! I’m using the OCUpload, or One Click Upload Plugin for Jquery. IE7 and IE8 is requiring me to do a double click to display the upload dialog box!
Solution: The one-click upload technique uses a trick that sets the file input’s browse button directly in front of your mouse cursor. This is misbehaving in [...]
Problem: Help! How can I pass parameters in my Bindings?
Solution: By using lambda functions in python(Check your PL’s manual for anything similar), you would be able to create on-the-fly functions that returns your bindings with the extra parameters/arguments you want to pass.
Example 1: Passing an argument to a wx Button Event
btn = wx.Button(self, [...]
Help! I’ve pasted some text from Microsoft Word and saved it to my SQL database! Now whenever I output my text there’s a bunch of diamonds with a question mark symbols now appearing!
A great IDE/editor to complement SQLite’s small footprint.
Problem: How do I set permissions to my files and/or directories without manually setting them up individually?
Note: You may need administrator privileges for these to work, if that’s the case simply add a sudo before typing the commands below.
If you want to chmod all your directories:
find . -type d -exec chmod 755 {} \;
and for [...]
A solution in python for displaying the count of your regular expression matches.
With all the sad stories of attempts in changing how the web works, it’s a good thing Opera did something that works very well even in a premature state(still in beta as I type)
Watch the following video to get the hands up of things:
Think of Opera Unite as creating your own server without any hassle [...]
