linking to unique category...

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jarv Members Profile Find Members Posts Groupie Joined: 15 December 2008 Status: Offline Points: 45	Post Options Post Reply Quote jarv Report Post Thanks(0) Quote Reply Topic: linking to unique category... Posted: 15 December 2008 at 5:06pm
	is it possible to order by the Category clicked? eg; if I clicked a link to C=3 can that be the first forum open at the top of the page? thanks

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 16 December 2008 at 7:43am
	It should be possible but would require modifying the SQL Query to change the order by clause. If you only wanted the category clicked on to display, you may also be able to alter the SQL Query to change the where clause to only return records for that category.
	Web Wiz Forums Hosting ASP.NET Web Hosting

jarv Members Profile Find Members Posts Groupie Joined: 15 December 2008 Status: Offline Points: 45	Post Options Post Reply Quote jarv Report Post Thanks(0) Quote Reply Posted: 16 December 2008 at 9:00am
	yes please can anyone help me with this?

jarv Members Profile Find Members Posts Groupie Joined: 15 December 2008 Status: Offline Points: 45	Post Options Post Reply Quote jarv Report Post Thanks(0) Quote Reply Posted: 17 December 2008 at 9:53am
	please help!

jarv Members Profile Find Members Posts Groupie Joined: 15 December 2008 Status: Offline Points: 45	Post Options Post Reply Quote jarv Report Post Thanks(0) Quote Reply Posted: 23 December 2008 at 9:22am
	can anyone help me here?

naruponk Members Profile Find Members Posts Newbie Joined: 24 January 2009 Status: Offline Points: 1	Post Options Post Reply Quote naruponk Report Post Thanks(0) Quote Reply Posted: 24 January 2009 at 2:30pm
	Not sure, is this link usful or not at least it should similar to your need http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.