Welcome To Snipplr


Everyone's Recent Snippets Tagged sql



1 ... 8 9 10 11 12 ... 17
0 582 posted 14 years ago by JohnnyGamba
0 809 posted 14 years ago by hamsterbacke82
Existen varias formas para hacerlo, pero lo que dejo aquí es a lo que tenemos que acostumbrarnos a hacer cada vez que programemos para prevenir que se pueda inyectar HTML o modificar las consultas SQL.\r\n\r\nThere are several ways to do it, but wha...
0 673 posted 14 years ago by arucordoba
create aspnet db in sql from .net tools
1 1005 posted 14 years ago by hairajeshk
By using this php snippnet we can store different fields (got by array post) into a sql database
1 867 posted 14 years ago by juanchifc
By using this snippnet we can recover and show on a table the items stored into a sql database managed with mysql.
1 841 posted 14 years ago by juanchifc
SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.
1 842 posted 14 years ago by errkk
1 633 posted 14 years ago by okepaing
To sort varchar fields which contain numeric data & returning XML
0 692 posted 14 years ago by aunlead
3 982 posted 14 years ago by jamiebrwr
First you have to add a custom value with a correct date format. The lines: `AND CAST(wpostmeta.meta_value AS DATE) > '".date("Y-m-d H:i:s")."' AND CAST(wpostmeta.meta_value AS DATE) < '".date("Y-m-d H:i:s", $date2)."' ` are only used to select d...
0 1475 posted 14 years ago by Mat_
0 1045 posted 14 years ago by tuffo19
1 764 posted 14 years ago by traeregan
1 1049 posted 14 years ago by traeregan
2 877 posted 14 years ago by samwa
2 861 posted 14 years ago by samwa
0 597 posted 14 years ago by foertel
You can get the last query by using the following code. Insert the first line before the query and TYPO3 will store each query. You can get the last query with the second line.
3 1006 posted 14 years ago by pogosheep
0 732 posted 14 years ago by florin555
1 933 posted 14 years ago by g8rpal
1 839 posted 14 years ago by cjcdeleon
2 849 posted 14 years ago by jx_boi
1 ... 8 9 10 11 12 ... 17