Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
[PHP-DB] Ordering Articles
0 views
Skip to first unread message
Jordan Elver
Mar 12, 2001, 7:24:43 AM3/12/01
to
Hi,
I'm trying to build an article management system. Basically it will have
normal artcile type things, a picture or two etc. The articles will be
ordered by date by default, but I want to include the option of being able to
order the articles if need be. i.e. say I add more artciles but i still want
one of the older artIcles to be at the top of the list, how would I do that?
I'm trying to build an article management system. Basically it will have
normal artcile type things, a picture or two etc. The articles will be
ordered by date by default, but I want to include the option of being able to
order the articles if need be. i.e. say I add more artciles but i still want
one of the older artIcles to be at the top of the list, how would I do that?
I hope this is clear,
Cheers,
Jord
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-un...@lists.php.net
For additional commands, e-mail: php-d...@lists.php.net
To contact the list administrators, e-mail: php-lis...@lists.php.net
Russ Michell
Mar 12, 2001, 7:29:10 AM3/12/01
to
Try:
"SELECT * FROM $table WHERE yourfield = '$somevar' ORDER BY
someotherField";
HTH :)
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
http://gertrude.sipu.anglia.ac.uk/webteam
r.j.m...@anglia.ac.uk
+44 (0)1223 363271 ext 2331
www.theruss.com
#-------------------------------------------------------#
0 new messages