Simple question on alphabetical output

elonkytroot

Hey, I have site where I post reviews, and I need to know how I can list the titles of the games reviewed in the database in alphabetical order. Right now, my code is

("SELECT * FROM $tablename WHERE complete!=0 ORDER BY id DESC LIMIT 0, $numArticles",$db);

and I need to change it from listing in order of creation to by the first letter. I am really new to php and would greatly appreciate the help.

Also: Right now I am using a config file that contains the variable of how many articles should be displayed. How can I change this so that it displays 15 or so and then creates a new page? (Example: First page has 15 entries, Second page has 15, keeps creating pages until it runs out.)

Thanks for the help!

FrozNic

instead of:
("SELECT * FROM $tablename WHERE complete!=0 ORDER BY id DESC LIMIT 0, $numArticles",$db);

try:

("SELECT * FROM $tablename WHERE complete!=0 ORDER BY id ASC LIMIT 0, $numArticles",$db);

// i've never written a query like this.. so i'm not sure what u'r trying to do.. but the desc makes it go from z-a where asc makes it go from a-z 🙂

elonkytroot

Nope, that doesn't work.

The way I posted orders by the id number in order of most recently created. The way you changed it only made it post from the first thing created down to the most recent. It had nothing to do with the text of the variable.

Thanks for trying.... if anyone else knows please tell me!

elonkytroot

Ok I figured it out... I had to use the ASC and change the id to the variable I wanted to use!

So, now that that is resolved, anyone have an answer to my second question?

Zack

See this thread: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10242489

we've spent A LOT of time on that...

you can see what I've done with that code so far here: http://ctmu.pcplayground.com/links_test.php