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

unread,
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 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

unread,
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