file path from sql query in drupal

Question

I'm wanting to get the filepath ie /sites/default/files/myfile.pdf for my file uploads.

I'm using the below:

$row['node_data_field_factsheet_field_factsheet_data']

this returns a:1:{s:11:"description";s:0:"";}

How do i get the actual path?

Here is my sql statement:

SELECT node.nid AS nid,
node_data_field_factsheet.field_factsheet_fid AS node_data_field_factsheet_field_factsheet_fid,
node_data_field_factsheet.field_factsheet_list AS node_data_field_factsheet_field_factsheet_list,
node_data_field_factsheet.field_factsheet_data AS node_data_field_factsheet_field_factsheet_data,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_fund node_data_field_factsheet ON node.vid = node_data_field_factsheet.vid
WHERE node.type in ('fund')

belongs on drupal.stackexchange.com

Cyclonecode
– Cyclonecode

2014-03-21 02:17:50 +00:00
Commented Mar 21, 2014 at 2:17 — Cyclonecode
– Cyclonecode, Commented Mar 21, 2014 at 2:17

alxp · Accepted Answer · 2009-07-09 11:28:30Z

2

You don't need to use SQL. Just call Drupal's file_create_path('myfile.pdf') function in the File API.

answered Jul 9, 2009 at 11:28

alxp

6,3611 gold badge25 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

file path from sql query in drupal

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related