(Answer) (Category) WebGUI FAQ : (Category) Web Design :
Add dropdown list of posted articles to User Profile
In conjunction with hj we came up with the following:
 <script type="text/javascript" language="JavaScript">
        <!-- 
        function GoThere(fe){
                var opt_key = fe.selectedIndex;
                var url_val = fe.options[opt_key].value;
                window.open(url_val,'_top');
                return true;
        }
        //-->
 </script>
<form name="form" method="post" action="">
<select onChange="GoThere(this);">
<option value="0">-- Choose One --</option>
^SQL("select
page.title,
page.urlizedTitle,
USS_submission.title,
USS_submission.userId,
USS_submission.USS_submissionId,
USS_submission.status,
USS_submission.image,
USS.wobjectId


 from USS_submission


 left join USS on USS_submission.USS_Id=USS.USS_Id
left join wobject on USS.wobjectId=wobject.wobjectId
left join page on page.pageId=USS_submission.pageId


 where USS_submission.userId='^FormParam(uid);' and USS.wobjectId=273  and USS_submission.status='approved'
order by USS_submission.dateSubmitted", <option value='^/1;'>^0;</option> );
</select>
</form>

wg-fomATgwyDOTorg
[Append to This Answer]
Previous: (Answer) TMPL_IF, TMPL_LOOP... What's it all about?
Next: (Answer) How do I add custom fields to USS? (6.2.x)
This document is: http://www.gwy2.org/cgi-bin/fom?file=46
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
This FAQ administered by ... Gerald Young