Snipplr

(PHP) GM Project 2012 (mod users) - cameronjrc

Sat, 04 May 2013 01:24:01 GMT

user modding for a forum based gaming website (file used in password protected directory)

(PL/SQL) Selecting a Random Row from Table in MySQL - apphp-snippets

Tue, 12 Mar 2013 22:09:43 GMT

Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

(SQL) How to select the first/least/max row per group in SQL - hairajeshk

Fri, 08 Jul 2011 14:45:56 GMT

max value record for each group

(MySQL) Automatic row numeration - grzebo

Wed, 06 Jul 2011 22:16:21 GMT

(C#) Single row from database - tonatiuh

Sun, 20 Feb 2011 09:06:26 GMT

(jQuery) jQuery Alternating Row Colors - BlueIceStudios

Tue, 18 Jan 2011 03:59:28 GMT

This one is simple yet very useful. You can do alternating row colors with 2 simple lines of jQuery

(jQuery) alternate table row - beso

Fri, 05 Nov 2010 21:40:32 GMT

(JavaScript) Highlight Table Row by Clicking on the Row - chopbust

Wed, 03 Nov 2010 18:53:14 GMT

This is a snippet to highlight the clicked row. The code is in Prototype library format. I am yet to port this into JQuery, but please do email me if you already did.

(jQuery) Making a table row clickable while preserving the function of additional links - theOtherOne

Sat, 09 Oct 2010 03:00:03 GMT

First: clicking on a table row forwards you to the URL given in the first As href attribute. ------ Second: clicking on a link inside the row triggers the default action **AND** a click event on the table row. This needs to be stopped, so the default action is replaced by our own and propagation to higher elements is stopped. ----- Nice to have: Hand cursor when hovering over a table row. CSS!

(JavaScript) Stripy Table - loric

Sun, 02 May 2010 03:46:28 GMT

(jQuery) Alternate Row Colors / Zebra Striping with jQuery - bradless

Thu, 11 Feb 2010 15:13:44 GMT

(PHP) PHP/MySQL - Get Table Data - kilrizzy

Tue, 02 Jun 2009 14:28:39 GMT

Use this function to print out all the rows in a table. Specify columns to show using the columnstring parameter: tablulardata(tablename, columnstring); ie: tabluardata("users","username=Username|fname=First Name|lname=Last Name");

(PHP) PHP/MySQL - Get Row Data - kilrizzy

Tue, 02 Jun 2009 12:57:06 GMT

Use this function to pull all columns from a single database field. getrowdata(tablename,rowid,prefix); You would call this function like: getrowdata("users",$_SESSION['user'],"user_"); The prefix is the prefix you want for the array names, so if I have a field in my "users" table called "username", the example above would output the variable "$user_username = 'data';"

(C#) ASP.net: Update SQL from a DropDownList dynamically created in a GridView. - jink

Mon, 01 Jun 2009 20:39:26 GMT

Bind the DropDownList like normal (set DataSourceID, DataTextField, DataValueField), and the SelectedValue field. AutoPostBack should be enabled. In the OnSelectedIndexChanged:

(SQL) Return a table list with row count - blackf0rk

Tue, 28 Apr 2009 14:18:29 GMT

This will return a list of all the tables in a certain database along with their row count.

(jQuery) Add table row to the bottom of a table - 1man

Fri, 20 Mar 2009 12:53:48 GMT

Great little snippit to add a to the bottom of a table. Note the use of the context in the jQuery e.g var n = $('tr:last td', this).length; Will have to use this in the future, very good to know!

(VB.NET) DataKey on RowDataBound - blackf0rk

Mon, 16 Mar 2009 12:40:35 GMT

If you need to get the DataKey value in RowDataBound (e.g. Assigning the DataKey to the CommandArgument of a button):

(PHP) execute row (retrieve one row) - ginoplusio

Tue, 11 Nov 2008 11:23:15 GMT

make a query and retrieve the first record, if error occurs show it and the query.

(ASP) Alternate row colors - f0vela

Thu, 13 Mar 2008 14:58:43 GMT

(JavaScript) MooTools alternate table row colors - gbot

Sat, 08 Mar 2008 10:51:21 GMT