Welcome To Snipplr


Everyone's Recent Snippets Tagged query



$quote -- name of function post_type=page -- remove to query posts orderby=rand -- random order showposts=1 -- limit to 1 post effect -- displays 1 random custom excerpt outside of the loop
1 659 posted 15 years ago by davebowker
Split and manipulate URLs easily with this module. It has similar interface to Python's urlparse library. This is patched and modified version from Denis's orignal implementation.
1 820 posted 15 years ago by miohtama
0 545 posted 15 years ago by iTony
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 711 posted 15 years ago by ginoplusio
0 673 posted 15 years ago by emoseman
Allows you preserve and update a query string and it's existing values easily, instead of constantly appending the new value to the end of the query string
1 825 posted 15 years ago by simplistik
It's easy to find the categories used on one item, but find all categories NOT used on current item? This snippet stores a "NOT IN" query. This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to w...
0 583 posted 15 years ago by stavelin
Nothing amazing here, just an efficient way to get the first row. Be sure to set your ORDER BY clause properly.
0 981 posted 15 years ago by stews
0 640 posted 15 years ago by stavelin
1 760 posted 15 years ago by plasticated
Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.
1 824 posted 15 years ago by stancell
0 562 posted 15 years ago by benpjohnson
Properly escapes the query string, according to http://code.google.com/apis/searchappliance/documentation/46/xml_reference.html#appendix_url_escaping
3 805 posted 15 years ago by AndrewVos
I often find something like this lurking at the end of my base templates - it'll show you which queries were run while generating the current page, but they'll start out hidden so as not to be a pain. Of course, before this works, you'll need to s...
1 843 posted 15 years ago by jonhenshaw
4 780 posted 16 years ago by mswallace
I modified some code created by Macromedia Dreamweaver into a flexible function to rebuild the query string. The function is very useful for pagination or passing variables from one page to another.In this version it's possible to add more than one v...
1 599 posted 16 years ago by gbot
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1 748 posted 16 years ago by ecavazos
1 729 posted 16 years ago by jpdamen
1 644 posted 16 years ago by jpdamen
1 663 posted 16 years ago by jpdamen
0 704 posted 16 years ago by capu
Para marcar navegaciones según la página.
2 728 posted 16 years ago by nicolaspar
1 596 posted 16 years ago by nicolaspar
This function extracts a value from a url. Very useful for tracking codes. For example, you have a url http://your.url/?source=666999, and you need the source number to be placed into a variable. Use the code below.
2 717 posted 17 years ago by 1man
in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename to return James Bond
1 668 posted 17 years ago by markireland
1 617 posted 17 years ago by gdonald