<div dir="ltr">I found my answer but I used PHP coding and there is probably a<div>better way using webform functions.</div><div>1) I create a page of type page</div><div>2) I added the below code to obtain and display my webform information</div><div>------------------------</div><div><div><?php</div><div>// set the table titles</div><div>$header = array('FIRST', 'LAST', 'COMMENT', 'ZIP', 'PHOTO');</div><div><br></div><div>// get data from webform_views_nestorwebform table</div><div>// this table is created by the webform_mysql_views module</div><div>// and it contains the data from a webform </div><div>$query = "SELECT first, last, comment, zip, photo FROM {webform_views_nestorwebform} where approved=1 ORDER BY first";</div><div><br></div><div>$q = db_query($query);</div><div><br></div><div>// move the returned array to $rows</div><div>while ($r = db_fetch_array($q)) {</div><div> $rows[] = $r;</div><div>}</div><div><br></div><div>for($i=0; $i<count($rows);$i++) {</div><div> foreach($rows[$i] as $key => $value) { </div><div> if($key == 'photo' && $value > 0) {</div><div> $fid=$value;</div><div> $myfile = db_fetch_object(db_query("SELECT * FROM {files} WHERE fid = %d", $fid));</div><div> $fname=$myfile->filename;</div><div> $fpath=$myfile->filepath;</div><div> $rows[$i][$key] = "<a href='$fpath'><img src='$fpath' width='50px' height='30px'></a><Br\n";</div><div> }</div><div> }</div><div>}</div><div><br></div><div>// the theme function automatically create the table title</div><div>// and display the data for the table</div><div>print theme('table', $header, $rows);</div><div><br></div><div>?></div></div><div>----------------------------------------</div><div><br></div><div>If you know a better way, please let me know,</div><div>Thanks!!!</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 28, 2014 at 12:29 PM, Néstor <span dir="ltr"><<a href="mailto:rotsen@gmail.com" target="_blank">rotsen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">when I do a select on teh webform_submitted_data table<div>select * from webform_submitted_data where nid=9515 and sid=1421;</div><div><br></div><div>the record where the image give me the number 673 </div><div><br></div><div>nid sid cid no data</div><div>9515 1421 6 0 673</div><div><br></div><div>How does that finds the path of the uploaded file?<br></div><div><br></div><div>HELP?</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 28, 2014 at 10:51 AM, Néstor <span dir="ltr"><<a href="mailto:rotsen@gmail.com" target="_blank">rotsen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">HI guys,<div><br></div><div>I am working with webform and so far so good but I am having the problem that when I createa form using webform and the form has a image upload I can not find the image url in the table.</div><div><br></div><div><br></div><div>I know where the images are on the server but nothing tells me which image goes with which submission.</div><div><br></div><div>If I edit the submission it shows the image path or URL but in the table where do I find this.</div><div>I do not see it in webform or webform_submissions o webform_submitted_data tables.</div><div><br></div><div>Where is the image url kept on the table?</div><div><br></div><div>thanks!!!</div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>