gettin a little complex here...

[slighltywhacked]

Hey, before I asked how to get results alphabeticly, and how to limit the amount of results I get by 20.

Now how do I use these together?
I understand this is probaly a lenghty process so if you dont really want to type it all out, at least redirect me to a site that can teach me this?

the list must first be sort from A-Z then pick 20 results from it?

thanx
Ryan Lahay

[Philip Olson]

is this from a SQL friendly database? if so, something similar to the following will be in (at the end of) your query :

ORDER BY sometablename ASC LIMIT 20

[slighltywhacked]

yes it is

so it owuld be like..

$sql= "SELECT * FROM list ORDER BY sometablename ASC LIMIT 20";

now lets say i have another collum of entries... and they contain values that are something like

red
blue
green
red
green
green
green
red

that collum was maybe.. er.. color ?

now lets say i hve another collom with something like
a
v
g
a
f
d
h
a
called letter

k... now I want to have a statement that will select only the color stored in $variable and then from those results list htem alphabeticly based on the letter collum, and for an extra twist, only have a max of 20

[qslack]

$sql= "SELECT * FROM list ORDER BY letter DESC LIMIT 20";

You would replace 'sometablename' with 'letter', since that is the column you want to order your results by.

BTW--I think it would be DESC instead of ASC. ASC would be backward-alphabetically.

[Philip Olson]

sounds like this is what you're after :

$sql = "SELECT * FROM list WHERE color='$variable' ORDER BY sometablename ASC LIMIT 20";

[slighltywhacked]

list is the name of the table that has all these values..
does that replace sometablename ?

Im pretty sure it does .. just double checkin

[slighltywhacked]

list is the name of the table that has all these values..
does that replace sometablename ?

Im pretty sure it does .. just double checkin

or is it supposed to be the collum that I want teh data to be sorted alphabeticly buy ..which in this case is "letter"

[Philip Olson]

sounds like you want sometablename to be 'letter'. In fact, whenever you see me writing sometablename pretend i wrote somecolumnname :-) oops!

[slighltywhacked]

thanx

been a great help

[slighltywhacked]

how about selecting everything that says an exact value (like "cow") from 3 different collums.. lets say the three are called "col1" "col2" "col3"

after getting those results, alphabeticly sort them by another collum called "name"

Do i just put three WHERE statement things in it?