/    Sign up×
Community /Pin to ProfileBookmark

Okay, what do I change here to make the comments in the comment box on my site appear from newest to oldest? The way it’s set now has the oldest comments at the top and the newest ones at the bottom near the text field.

$commentquery = mysql_query(“SELECT * FROM comments WHERE tutorialid=’$tutid’ ORDER BY date”) or die(mysql_error());

I know “date” has to be changed, but I can’t figure to what.

to post a comment
PHP

2 Comments(s)

Copy linkTweet thisAlerts:
@NogDogJun 24.2008 — Add a [b]DESC[/b] (for "descending") at the end of the query.
Copy linkTweet thisAlerts:
@VanterionauthorJun 24.2008 — Wow

Thanks a lot, NogDog!!
×

Success!

Help @Vanterion spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.24,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...