http://www.cybervaldez.com Thu, 15 Jul 2010 06:04:39 +0000 http://backend.userland.com/rss092 en Awesome, it seems that mySQL now supports the OFFSET clause. This is very useful for paginating your SQL statements. The following will return the first 10 entries of your select statement: "SELECT field FROM table LIMIT 10" This, on the otherhand, will OFFSET your result by 10, selecting your entries #10-20: "SELECT field FROM table ... http://www.cybervaldez.com/mysql-super-tip-use-limit-and-offset-to-paginate-your-select-statements/2010/ _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 ... http://www.cybervaldez.com/mysql-simplify-your-multiple-where-queries-with-where-in/2010/ Problem #1: Help Me! How do I install Windows 7 in my macbook while retaining Mac OSX. Problem #2: Driver issues! I can't install my 64 bit bootcamp drivers in Windows 7! Problem #3: Sound: My Macbook sounds very tinny and awful in Windows 7 Problem #4: Right Clicking: How do ... http://www.cybervaldez.com/ultimate-guide-to-installing-windows-7-64-bitx64-in-your-macbook-white-and-solutions-to-bootcamp-driver-problems/2009/ 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 ... http://www.cybervaldez.com/super-tip-how-to-create-that-floating-facebook-toolbar-at-the-bottom-of-the-page/2009/ 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 ... http://www.cybervaldez.com/jquery-super-tip-automatically-highlight-the-linksmenu-of-the-current-page-with-1-line-of-code/2009/ 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 ... http://www.cybervaldez.com/how-to-fix-ocuploadone-click-upload-clicking-bug-in-ie7-ie8-jquery/2009/ Problem: I've decided to re-install windows because of some issues. My new install is ok but I can't delete the directory of my old windows anymore! Solution: The folder you are trying to delete has it's administrative privileges locked from your previous windows. You could change the ownership of your folder ... http://www.cybervaldez.com/how-to-deleteremove-protected-folders-and-files-from-a-previous-installation-of-windows/2009/ 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 ... http://www.cybervaldez.com/super-tip-pass-arguments-in-your-python-bindings-using-lambda-functions/2009/ Problem: Help! My mask clipping isn't working because of the my layer's overlay effect! I need to rasterize my effects first but I don't know how! Solution: Step 1: Select the layer with the effects you want rasterized. Step 2: Press Control(CMD for Mac)+Shift+N to create a new layer. Step 3: Add the ... http://www.cybervaldez.com/super-tip-rasterize-a-layer-with-its-effect-in-photoshop/2009/ Problem: Help! I need to replace some words with something else in my database. Solution: Use the replace() function to do a search and replace query. UPDATE table_name SET table_field=REPLACE(table_field,"old_text","new_text"); Here's an example: UPDATE wp_posts SET post_content=REPLACE(post_content,"localhost","www.cybervaldez.com"); Easy as pie! No related posts. http://www.cybervaldez.com/super-tip-a-mysql-query-to-find-replace-text-in-your-database/2009/