All MySQL Important Query's at one place

SQL List of Articles

Introduction SQL Introduction Access to MySQL Insert Query MySQL insert with set option Update Query Replace command in SQL query SQL Delete Query  Manageing the records Checking if Record exists How to get second highest record Where Query SQL IN SQL OR AND SQL Limit Random Record Select Query Sql Group by Sql Group with sub groups MySQL Having Avoid duplicate records using Distinct SQL SQL Between SQL Like SQL Order By user to change the record display order ? Inserting sum of a column in other table Updating other table concat:Adding string to data Length of characters present in a field  MySQL Functions MySQL Affected rows MySQL insert ID MySQL error number MySQL error message MySQL error posting MySQL number of rows MySQL Auto increment number Starting Auto increment number with a value MySQL Version MySQL functions

Full Articles -
http://www.plus2net.com/sql_tutorial/replace.php

Facebook’s Stream.Publish method on browsers with popup blockers

How to use Facebook’s Stream.Publish method on browsers with popup blockers. See a demo.

What is the problem?

Recently many Facebook developers have been frustrated by popup blockers preventing the Stream Publish dialogue box from being displayed. If a user hasn’t logged in and authorised the application, dialogue boxes are shown in a popup window instead of an iframe. That’s fine for some visitors, but for those who have a popup blocker enabled, it means that they won’t see the dialogue box and therefore can’t publish a post into the stream.

The Stream Publish dialogue being displayed in an iframe.

The Stream Publish dialogue being displayed in a popup window. Popup blockers will prevent this from opening.


URL: http://labs.thesedays.com/2010/08/11/publishing-facebook-stories/

Query Grid 3.1

Query Grid 3.1- Datagird plugin for jQuery, where the user can manipulate the number of requested pages with adding, updating, deleting row data.

• Live Demo: Here
• Download Code: From Here
• http://www.trirand.com/blog/?p=13

Latest in “jQuery”

AJAX-ed To Do List With PHP, jQuery & MySQL

A Simple Movie Search App w/ jQuery UI 

An AJAX Click to Appreciate Badge 

Making a Custom YouTube Video Player With YouTube’s APIs

Colortip – a jQuery Tooltip Plugin

Making a Slick MobileApp Website with jQuery & CSS

See Full Articals:

http://tutorialzine.com/category/tutorials/jquery-tutorials/