Format

The Format setting controls the overall format for the list of information in your view.

By default, you can choose from these formats:

Configuring a view

Once you've created a view, you can customize it further - you can control the view's

What is Views?

The views module allows administrators and site designers to create, manage, and display lists of content. Each list managed by the views module is known as a "view", and the output of a view is known as a "display". Displays are provided in either block or page form, and a single view may have multiple displays. Optional navigation aids, including a system path and menu item, can be set for each page-based display of a view.

Views 3

The documentation for Views 2 and Views 3 for Drupal 6 and Drupal 7 is contained within Views module. Install the Advanced Help module to access it.

These handbook pages are based on the Advanced Help content, and are included in the handbook for easier searching.

Working with Views in Drupal 7 and earlier

The documentation for Views 2 and Views 3 for Drupal 6 and Drupal 7 is contained within Views module! Install the Advanced Help module to access it.

Advanced help for viewsScreenshot example showing Advanced Help when clicking on the "?".

Which Branch: Views 1, Views 2 or Views 3?
Views 1.x is for Drupal 5 (and earlier). Views 2.x and 3.x are for Drupal 6. Views 3.x is for Drupal 7.

Drush SQL Query (sql-query, sqlq)

Below you find some examples of howto use the Drush sql-query (alias : sqlq) command.

Show information of user 1:
drush sql-query "SELECT * FROM users where uid=1"

Troubleshooting

error: system() has been disabled for security reasons

To resolve, go to your (local or global) php.ini and temporarily remove 'system' from the disable functions parameter:

Example:

Change
disable_functions = show_source, system, shell_exec, passthru, exec, phpinfo, shell, symlink
To:
disable_functions = show_source, shell_exec, passthru, exec, phpinfo, shell, symlink

Warning: this exposes some security risks, so there must be a better way to do it with PHP, without using the 'system()' function.

Using a custom php.ini
Please see the page Modifying the PHP or PHP configuration that drush runs under for instructions on creating a custom php.ini file for Drush.

Custom version of the php.ini file

You can use something like this to invoke a custom version of the php.ini file you want to use with Drush. The PHP command argument -c ini-file will allow you to specify a custom .ini file to use with Drush.

Pages

Subscribe with RSS Subscribe to RSS - SQL queries