Database Reference
In-Depth Information
WHERE 1 is a condition that is always true. Therefore, the query can be executed
as it is. We can replace 1 with the condition we want, or we can type a completely
different query.
The Fields selector
The Fields selector is a way to speed up query generation. By choosing a field and
clicking on the arrows << , this field name is copied at the current cursor position in
the query box. Here, we select the author_id field, remove the digit 1, and click <<.
Then we add the condition = 2 .
The Show this query here again option (checked by default) ensures that the query
stays in the box after its execution if we are still on the same page. This can be seen
more easily for a query like an UPDATE or DELETE , which affects a table, but does not
produce a separate results page.
Clicking into the query box
We might want to change the behavior of a click inside the query box with the
$cfg['TextareaAutoSelect'] configuration directive. Its default value is FALSE ,
which means that no automatic selection of the contents is done upon a click. Should
you change this directive to TRUE , the first click inside this box will select all its
contents. (This is a way to quickly copy the contents elsewhere or delete them from
the box.) The next click would put the cursor at the click position.
 
Search WWH ::




Custom Search