Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

All pages tagged QUERY

PHP: How to connect to MySQL database using PHP

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running. More...

Tags: PHP CONNECTION DATABASE MYSQL FUNCTIONS RETRIEVE PRINT SQL QUERY Hits: 184267 Comments: 25

jQuery File Upload

Wow, Yet another upload plugin! What makes it different?

  • It's new. Supports all modern technologies.
  • It's good looking and works out of the box. Based on Bootstrap and Glyphicons icons.
  • Cross domain upload, client size images resing.
  • Supports multiple platforms (PHP, Python, Ruby on Rails, Java, Node.js, etc)

More...

Tags: PHP UPLOAD JQUERY PYTHON Hits: 88360 Comments: 0

SQL: IN Operator

In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to the Where clause. When used in this context, we know exactly the value of the returned values we want to see for at least one of the columns. More...

Tags: SQL IN WHERE QUERY RANGE INCLUSION EXCLUSION Hits: 47340 Comments: 2

SQL: ORDER BY

The Order By clause imposes an order on the query results. More...

Access: Sum Function

In Access, the Sum function returns the sum of a set of values in a set of values in a select query. More...

Tags: ACCESS FUNCTION SUM SELECT QUERY VALUE Hits: 42441 Comments: 1

SQL: DISTINCT Clause

The Distinct keyword eliminates duplicate rows from the query results. More...

Tags: SQL DISTINCT DUPLICATE ELIMINATION QUERY Hits: 42231 Comments: 3

SQL: HAVING Clause

The Having clause is optional and used in combination with the Group By clause. It is similar to the Where clause, but the Having clause establishes restrictions that determine which records are displayed after they have been grouped. More...

Tags: SQL HAVING QUERY GROUPBY RESTRICT DETERMINE DISPLAY Hits: 41948 Comments: 0

SQL: Join

Single table queries are useful but they do not exploit the full power of the SQL language. SQL is relational database query language and as such, one of its most important features is its ability to retrieve information from several different related tables. In relational database terms, this process is called a join. More...

Tags: SQL JOIN QUERY RETRIEVE RELATIONSHIPS MATCHING Hits: 28703 Comments: 1

SQL: INSERT Statement

The Insert Into statement can be used to append a record to a table or to append multiple records from one table to another. More...

Tags: SQL INSERT QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 28116 Comments: 2

ASP Request Object

The Request object retrieves the values that the client browser passed to the server during an HTTP request. It is used to get information from the user. Using this object, you can dynamically create web pages and perform various server-side actions based on input from the user. In this tutorial the syntax, collections, properties and methods of the ASP Request object are described. More...

Access: Max function

In Access, the Max function returns the maximum of a set of values in a select query. More...

Tags: ACCESS FUNCTION MAX MAXIMUM SELECT QUERY Hits: 24811 Comments: 0

SQL: Union Clause

The Union clause allows you to combine the result sets of 2 or more individual queries. More...

Tags: SQL UNION QUERY COMBINE RESULTS SELECT Hits: 23788 Comments: 1

SQL: LIKE Condition

The Like condition allows you to use wildcard characters to specify one or more string character values. More...

Tags: SQL LIKE CONDITION WHERE QUERY WILDCARD PATTERN Hits: 23443 Comments: 0

SQL: UPDATE Statement

The Update statement allows you to update a single record or multiple records in a table. More...

Tags: SQL UPDATE QUERY SINGLE MULTIPLE RECORDS Hits: 21359 Comments: 0

Access: Last Function

In Access, the Last function return a field value from the last record in the result set of a query. More...

Tags: ACCESS FUNCTION LAST RESULT RECORDSET QUERY Hits: 21294 Comments: 0

Access: Avg function

In Access, the Avg function calculates the arithmetic mean of a set of values in a select query. More...

Tags: ACCESS FUNCTION AVG ARITHMETIC_MEAN SELECT QUERY Hits: 19323 Comments: 0

SQL: GROUP BY

The Group By clause of the Select statement lets you split up the values in a column as a whole. More...

Tags: SQL GROUPBY QUERY COMBINE RECORDS AGGREGATE SUM COUNT MIN MAX Hits: 19175 Comments: 0

SQL: BETWEEN ... AND...

The Between keyword allows you to define a predicate in the form of a range. More...

Tags: SQL BETWEEN QUERY PREDICATE RANGE UBOUND LBOUND Hits: 18451 Comments: 0

Access: Min function

In Access, the Min function returns the minimum of a set of values contained in a select query. More...

Tags: ACCESS FUNCTION MIN MINIMUM SELECT QUERY Hits: 14522 Comments: 0

SQL: DELETE Statement

The Delete statement allows you to delete a single record or multiple records from a table. More...

Tags: SQL DE;ETE QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 12727 Comments: 0

SQL: WHERE Clause

The Where clause is used to specify that only certain rows of the table are displayed, based on the criteria described in that Where clause. More...

Tags: SQL WHERE QUERY CRITERIA SELECTIVELY RETRIEVE Hits: 12203 Comments: 1

SQL: AND/OR conditions

The scope of the Where clause and the operators used with it can be extended by using the logical operators AND and OR. More...

Tags: SQL AND OR CONDITION LOGICAL OPERATORS SEARCH QUERY Hits: 11113 Comments: 0



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.