Programming Help

Web Development



What's Here?

  • Members: 117,613
  • Replies: 431,996
  • Topics: 66,701
  • Snippets: 2,395
  • Tutorials: 631
  • Total Online: 1,970
  • Members: 51
  • Guests: 1,919

Who's Online?

Welcome to Dream.In.Code
Click Here
Getting PHP Help is Easy!

Join 117,613 PHP Programmers for FREE! Ask your question and get quick answers from experts. There are 1,970 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



mysql query

 
 Reply to this topicStart new topic

mysql query, sort by number of records in table
darvatkarg
post 2 Jul, 2008 - 06:06 AM
Post #1


New D.I.C Head

*
Joined: 2 Jul, 2008
Posts: 1
plz tell me mysql query to sort the records in ascending order and print.

thanks
User is offlineProfile CardPM

Go to the top of the page


jjsaw5
post 2 Jul, 2008 - 06:13 AM
Post #2


D.I.C. Face

Group Icon
Joined: 4 Jan, 2008
Posts: 1,074



Thanked 5 times

Dream Kudos: 125
My Contributions
We can't give you that information because you have not given us any information about your database.

You should try it on your own and then post what you have done and we will help you then.


We are not here to do your work for you.

This post has been edited by jjsaw5: 2 Jul, 2008 - 06:14 AM
User is offlineProfile CardPM

Go to the top of the page

akozlik
post 2 Jul, 2008 - 11:21 AM
Post #3


D.I.C Addict

Group Icon
Joined: 25 Feb, 2008
Posts: 527



Thanked 19 times

Dream Kudos: 750
My Contributions
use the ORDER BY clause with either ASC or DESC

For instance, lets say you have a table named users with a bunch of fields in it. You want to sort it by alphabetical order ascending based on the username. Your sql select would be

php

$sql = "select * from users order by username asc";
$result = mysql_query($sql) or die ( mysql_error() );


That would put the resulting query in alphabetical order. Just apply this technique to your specific program.

For more information on ORDER BY visit http://www.w3schools.com/sql/sql_orderby.asp
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/7/08 11:53PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month