Search found 11 matches
- Fri Feb 15, 2008 9:30 am
- Forum: Joomla! Extensions Directory Forum
- Topic: Extensions comments ranking - please change to list by most
- Replies: 5
- Views: 1211
Re: Extensions comments ranking - please change to list by most
You guys are awesome! - Looks great - thanks for your hard work and for listening
- Fri Feb 01, 2008 9:58 am
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
Re: php and mysql Order By help
CirTap - I just can't say how useful your advice has been - Thank you for all your time and advice. Once I've added the admin interface I'll let you know if you're interested to see it working... the component provides full text indexing of docs in the docman folder (pdf's and office doc...
- Thu Jan 31, 2008 5:37 pm
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
Re: php and mysql Order By help
Last thing... If I'm doing this: $db =& JFactory::getDBO(); $query = 'CREATE TABLE ' . $table . ' ( rank int(10) NOT NULL, filename varchar(150) NOT NULL, filesize varchar(10) NOT NULL, IN...
- Thu Jan 31, 2008 5:25 pm
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
Re: php and mysql Order By help
You need to call $db->query() to execute it. :-[ whoops! Thanks! ---- Delay while testing ------ ;D ;D ;D ;D It's working!!! CirTap Thank you!! woohoo! I now have a working set of results joining indexing server query results with #__docman enabling sorting by ranking etc......
- Thu Jan 31, 2008 1:40 pm
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
Re: php and mysql Order By help
Have fun :D thanks! PS the ranking data is only available in the array rather than the database, thus I think I need to create the in-memory table to then JOIN it with docman to then use the subquery... The problem though is that when I use e.g. $db =& JFactory::getDBO(); $table = "#__docsearch_res...
- Wed Jan 30, 2008 3:03 pm
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
Re: php and mysql Order By help
The filenames must not be in asc/desc order but by the order provided in the IN() clause CirTap - Thanks so much for your reply. Yes - you are right I need to do the above. You are also right in saying that MySQL is returning the data by order of the primary key - not datepublished - they jus...
- Wed Jan 30, 2008 12:59 pm
- Forum: Joomla! Coding 101
- Topic: php and mysql Order By help
- Replies: 10
- Views: 1268
php and mysql Order By help
Hi. I'm writing a component for joomla which searches inside files stored on the server and I'm returning a list of filenames from a search engine indexing catalog (implode from an array) into a query that looks like this: SELECT * FROM #_document_table WHERE filename in ('filename1', 'filename2', '...
- Tue Jan 15, 2008 10:56 am
- Forum: Joomla! Coding 101
- Topic: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?
- Replies: 1
- Views: 465
Re: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a mo
ok - I got my head all twisted.
I'm trying to do something in the template that should be done in the view!
I've restructured my code and all working. phew!
I'm trying to do something in the template that should be done in the view!
I've restructured my code and all working. phew!
- Tue Jan 15, 2008 10:53 am
- Forum: Joomla! Extensions Directory Forum
- Topic: Extensions comments ranking - please change to list by most
- Replies: 5
- Views: 1211
Re: Extensions comments ranking - please change to list by most recent
Hey Rliskey - great idea - commeting via version number would be great, however I imagine it's quite difficult to incorporate existing comments into this..?
If extensions were just listed by date, at least the latest review would correspond more accurately to the latest version number...
If extensions were just listed by date, at least the latest review would correspond more accurately to the latest version number...
- Mon Jan 14, 2008 3:30 pm
- Forum: Joomla! Coding 101
- Topic: J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?
- Replies: 1
- Views: 465
J!1.5 M-V-C - view.html... How to pass a variable back to a function in a model?
Hi. I'm trying to work my way through this M-V-C thing.. Basically, I've got a variable in com_mycomponent/views/mycomponent/tmpl/default.php Which looks like this: $file = $fileRS->fields['filename']->value; It returns the filename of a document from an Indexing Server Catalog object.&...
- Wed Jan 09, 2008 1:08 pm
- Forum: Joomla! Extensions Directory Forum
- Topic: Extensions comments ranking - please change to list by most
- Replies: 5
- Views: 1211
Extensions comments ranking - please change to list by most
Guys - Thanks for a great site. Just wanted to post a request for a change to the Extensions Directory... The list of User Reviews seems to be ranked by Number of people who found this review helpful rather than date. This is actually really frustrating as a lot of extensions l'm looking at downloa...