Index
S
search
engines, Searching for Jokes
SELECT, Viewing Stored Data, Managing Authors, SELECT-Joins
aliases in, Column and Table Name Aliases
building
dynamically with PHP, Searching for Jokes
GROUP
BY clause, SELECT
GROUP BY clause, GROUPing SELECT Results
grouping results, GROUPing SELECT Results-GROUPing SELECT Results
HAVING clause, Limiting Results with HAVING, SELECT
INTO clause, SELECT
LEFT JOIN
... ON, LEFT JOINs
LIKE operator, Viewing Stored Data, Searching for Jokes
LIMIT clause, Setting LIMITs
limiting
number of results, Setting LIMITs
ORDER
BY clause, SELECT
ORDER BY clause, Sorting SELECT Query Results
SELECT DISTINCT, Rule of Thumb: Keep Things Separate
sorting
results, Sorting SELECT Query Results
WHERE clause, Viewing Stored Data, SELECT
with
multiple tables, Dealing with Multiple Tables
semi-dynamic
pages, Semi-Dynamic Pages
server side includesincreasing
security with, Increasing Security with Includes
server-side includes, Server-Side Includes with PHP
server-side languages, Introducing PHP
advantages of, Introducing PHP
compared to JavaScript, Introducing PHP
session_destroy, PHP Sessions
session_start, PHP Sessions
sessions, PHP Sessions
SET, SET
setcookie, Cookies
short-circuit
evaluation, Assigning Unique File Names
SHOW, SHOW
SHOW DATABASES, Logging On to MySQL
SHOW TABLES, Creating a Table
special characters, Editing Authors,Index, see also escaping special
characters
split, Splitting Text into Pages
spliti, Splitting Text into Pages
SQL, see structured query language
statements, Basic Syntax and Commands
str_replace, Matching Tags
stripslashes, Magic Quotes
strlen, Viewing Stored Files
strpos, Viewing Stored Files
Structured Query Language, Who Should Read This Book, So what's SQL?
sub-selects, CREATE TABLE
summary
functions, GROUPing SELECT Results
summary functions, GROUPing SELECT Results, GROUPing SELECT Results, Functions for Use with GROUP BY Clauses, see also mysql functions