Sorry if this has been asked before, but I can't seem to find it now, or find anything by searching. I remotely remember a mod for Links 2.0 which would randomly pick a letter to start a category with instead of always following the order of A, B, C, etc. For example if I do a build this time it will start with the letter C and then build it alphabetically, all they way back through B. The next build it might start with S, and so on and so forth. If anyone can either tell me how I can do this or point me to some instructions it would be appreaciated. This would be for the LSQL version, not 2.0
Apr 8, 2003, 1:06 PM
Novice (32 posts)
Apr 8, 2003, 1:06 PM
Post #2 of 4
Views: 2352
OK... this is what I was looking for. I haven't compared Links 2.0 to Links SQL. Is this possible to do with Links SQL?
http://www.gossamer-threads.com/...rces/jump.cgi?ID=474
http://www.gossamer-threads.com/...rces/jump.cgi?ID=474
Apr 8, 2003, 1:41 PM
Veteran / Moderator (6956 posts)
Apr 8, 2003, 1:41 PM
Post #3 of 4
Views: 2354
Hmmmm.....
If you wanted to do a "random" build, I think there are some threads on a random search order, but not a start-with-a-letter and rotate type discussions.
The most recent version(s) of MySQL supports a "random" parameter to be used in the Order statement, which should do something like what you want.
check out:
http://gossamer-threads.com/perl/gforum/gforum.cgi?do=post_view_flat;post=129557
PUGDOG� Enterprises, Inc.
The best way to contact me is to NOT use Email.
Please leave a PM here.
If you wanted to do a "random" build, I think there are some threads on a random search order, but not a start-with-a-letter and rotate type discussions.
The most recent version(s) of MySQL supports a "random" parameter to be used in the Order statement, which should do something like what you want.
check out:
http://gossamer-threads.com/perl/gforum/gforum.cgi?do=post_view_flat;post=129557
PUGDOG� Enterprises, Inc.
The best way to contact me is to NOT use Email.
Please leave a PM here.
Apr 9, 2003, 8:44 AM
Novice (32 posts)
Apr 9, 2003, 8:44 AM
Post #4 of 4
Views: 2333
Thanks for the link! The 'rand()' function works great! I just wanted to give everybody the ability to be seen instead of having somebody's site which starts with Z never be seen because they are at the bottom of the list always.
BTW... if anyone is able to make it rotate the listings alpabetically that would be even better!
BTW... if anyone is able to make it rotate the listings alpabetically that would be even better!