Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [sooke] Editors Online: Table Join Prob: Edit Log

Here is the list of edits for this post
Re: [sooke] Editors Online: Table Join Prob
I guess what I am trying to say is:

@list = SELECT 'Full_Name" From Category Where (Category.ID=>Editors.CategoryID) AND ( Editors.User =>$user ) to return Category.Full_Name fetchall_list

My bad attempt ->

@editor_categories = $DB->table('Editors','Category')->select({'Category.ID'=>'EditorCategoryID'},{Username => $user}, ['Category.ID', 'Category.Full_Name'])->fetchall_list;


Links Plugins

Last edited by:

sooke: May 17, 2002, 1:11 PM

Edit Log: