Databases Reference
In-Depth Information
Creating a Bookmark after a Successful
Query
Initial bookmark creation is made possible by the
Bookmark this SQL-query
button. This button appears only after execution of a query that generates results
(when at least one row is found), so this method for creating bookmarks only stores
SELECT
statements. For example, a complex query produced by the multi-table
query generator (as seen in Chapter 13) could be stored as a bookmark in this way,
provided it finds some results.
Let's see an example. In the
Search
page for the
book
table, we select the
fields that we want in the results, and enter the search values as shown in the
following screenshot:
After clicking
Go
, we see that the results page has a bookmark dialog. We have
to enter only a label for this bookmark and click
Bookmark this SQL-query
to
save this query as a bookmark. Bookmarks are saved in the table defined by
$cfg['Servers'][$i]['bookmarktable']
.
Search WWH ::
Custom Search