A

Index
byGareth Downes-Powellet al.
Wrox Press 2003

ADD expression, ALTER TABLE

column, adding to table, 190

create_definition, 191

indexes, creating, 194

advanced recordsets

hotel booking system, 149

reasons for using, 142

search engines, building queries, 207

parameters, adding, 208

Advanced section, New Optional Region, 114

see also Basic option.

aliasing recordset columns, 171

ALTER expression, ALTER TABLE

column default value, altering, 191

ALTER TABLE command, SQL, 190

indexes, handling on existing tables, 194

altering NOT possible, 195

creating, ADD, 194

deleting, DROP, 195

syntax, altering table structure, 190

ADD, adding column, 190

ALTER, altering column default value, 191

CHANGE, modifying field definition, 191

DROP, removing column, 191

IGNORE, handling unique key duplicates, 190

RENAME, renaming table, 191

Answers panel, Dreamweaver MX, 18

Apache web server

configuring, PHP Linux installation, 25

configuring, PHP Windows installation, 23

PHP as Apache module, 23

Application panel, Dreamweaver MX, 16

Databases/Bindings/Server Behaviors/Components sub-panels, 16

arrays, PHP, 221

debugging, custom function example, 310

ASP (Active Server Pages)/ASP.NET, 9

as PHP alternatives, 9

Assets panel, Files, 17

auto_increment attribute, primary keys, 193

avg(expr) function, MySQL, 186

GROUP BY using, 186