Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [minesite] Links sorting

Quote Reply
Re: [minesite] Links sorting In reply to
ok,
this is my links database dump:
CREATE TABLE Links (
ID int(10) unsigned NOT NULL auto_increment,
Title varchar(100) NOT NULL default '',
LinkOwner varchar(50) NOT NULL default 'admin',
Add_Date date NOT NULL default '0000-00-00',
Mod_Date date NOT NULL default '0000-00-00',
Description text,
Hits int(11) NOT NULL default '0',
isNew enum('No','Yes') NOT NULL default 'No',
isChanged enum('No','Yes') NOT NULL default 'No',
isPopular enum('No','Yes') NOT NULL default 'No',
isValidated enum('No','Yes') NOT NULL default 'Yes',
Rating float(12,2) NOT NULL default '0.00',
Votes smallint(5) unsigned NOT NULL default '0',
Status smallint(6) NOT NULL default '0',
Date_Checked datetime default '0000-00-00 00:00:00',
Timestmp timestamp(14) NOT NULL,
URL varchar(255) NOT NULL default 'http://',
Contact_Name varchar(255) default NULL,
Contact_Email varchar(255) default NULL,
Icon varchar(255) default NULL,
SendLinkOwner int(11) default '0',
Recommended int(11) default NULL,
Link_Status int(11) default '0',
Detailed_Hits int(11) default '0',
AlertMessage varchar(255) default 'NotSent',
Expired_Flag varchar(255) default '0',
Links_type varchar(255) default NULL,
Logo varchar(255) default NULL,
link_has_attachments tinyint(4) default '0',
Top_Order int(11) default '0',
Hits_Bak int(11) default '0',
Screenshot varchar(255) default '',
PRIMARY KEY (ID),
KEY userndx (LinkOwner),
KEY popndx (isPopular),
KEY stndx (Status),
KEY newndx (isNew),
KEY valndx (isValidated),
KEY URL_idx (URL)
) TYPE=MyISAM;

The Links_type column have 3 values for every link:
value_1
value_2
value_3

On the search page and category page how I can set all links with value_1 at the top ?????
what I must change on build_sort_order_search and on build_sort_order_category ??
Have Understand ???

Thanks


Thanks in Advance
Bye From Italy
Subject Author Views Date
Thread; hot thread Links sorting fabio 5181 Mar 12, 2004, 3:38 AM
Thread; hot thread Re: [fabio] Links sorting
minesite 5057 Mar 12, 2004, 6:16 AM
Thread; hot thread Re: [minesite] Links sorting
fabio 5060 Mar 12, 2004, 6:45 AM
Thread; hot thread Re: [fabio] Links sorting
Payooo 5064 Mar 12, 2004, 7:00 AM
Thread; hot thread Re: [Payooo] Links sorting
fabio 5075 Mar 12, 2004, 7:04 AM
Post; hot thread Re: [fabio] Links sorting
Payooo 5073 Mar 12, 2004, 7:14 AM
Post; hot thread Re: [fabio] Links sorting
minesite 5040 Mar 12, 2004, 7:17 AM
Thread; hot thread Re: [fabio] Links sorting
minesite 5045 Mar 12, 2004, 7:20 AM
Thread; hot thread Re: [minesite] Links sorting
fabio 5046 Mar 12, 2004, 7:22 AM
Thread; hot thread Re: [fabio] Links sorting
minesite 5043 Mar 12, 2004, 7:35 AM
Thread; hot thread Re: [minesite] Links sorting
fabio 5034 Mar 12, 2004, 8:05 AM
Post; hot thread Re: [fabio] Links sorting
minesite 5026 Mar 12, 2004, 8:22 AM
Thread; hot thread Re: Setting up Priority Links
BabiesOnline 4882 Aug 4, 2004, 12:03 PM
Post; hot thread Re: [BabiesOnline] Setting up Priority Links
minesite 4860 Aug 4, 2004, 4:37 PM