<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18876">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>I need a proper download counter but the 2-3 that
exist are not up to scratch so I decided to make my own SQL queries for each
node page, showing some download stats. </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I then had the idea of creating a view on each
user's account page showing the number of downloads their content had produced.
Again, I have the SQL query all ready but wanted to somehow incorporate it into
a view. Is there any way of doing that?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Can I create what would be essentially an "empty"
field, then populate it with what my sql query returns?? I'm a little nervous of
using sql queries raw on my template files.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>what would be the best way of implementing
something like this?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards<BR><BR>Neil</FONT></DIV></BODY></HTML>