How to use drupal variable in sql query in view

The drupal website path is http://domain/v1/v2/v3

and the varials in the path is arg(0)=v1, arg(1)=v2 and arg(2)=v3

So in your sql command in view, you can use like this:

$argument= arg(1);

$view--> build_info['query']="select * from table_name where name='$argument'";

Note:

1. there is no need to add schema name in front of the table name even the schema is not public

2. give alias name to each table and field

SELECT feature.feature_id AS feature_id,
    feature.uniquename as feature_uniquename
      FROM feature feature
      LEFT JOIN featureloc fl ON feature.feature_id = fl.feature_id
      LEFT JOIN feature srcf ON fl.srcfeature_id = srcf.feature_id
      WHERE srcf.name = '$argument'"

Implementing Custom Query for Drupal View

http://drupal.org/node/409808

Drupal and Imagecatch problem (Imagecache seems to work only if thefile system is set to private)

The problem is th epath to the image uploaded does not work correctly.
If you set the File system to Private under Administrator>>Files System, th epath problem is sovled. However this solution will affect other Drupal Modules.
I have tried other ways :

1. set the permission for pth "/var/www/drupal/sites/default" to 777----doe snot work.
2. change the content of .htaccess---doe snot work

The following seems a coorect way to do so:
"Changed case FILE_DOWNLOADS_PUBLIC to be the same as case FILE_DOWNLOADS_PRIVATE and Voila: It worked!. I am now thinking that this must be a path issue of some sort? Assuming that this is the case, I'm changing the status on this to bug report. Correct me if I'm being premature (or just wrong)."

Source:

• http://drupal.org/node/399790#comment-1428428
• http://drupal.org/node/366177