table record intervals

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
pedroz
Forum Commoner
Posts: 99
Joined: Thu Nov 03, 2005 6:21 am

table record intervals

Post by pedroz »

I have the following scenario

table
amount | letter
1 | a
5 | b
7 | c

I need a query if
amount=1,2,3,4,5 it displays letter a
amount=6,7 it displays letter b
amount=8,9,... it displays letter c
User avatar
a94060
Forum Regular
Posts: 543
Joined: Fri Feb 10, 2006 4:53 pm

Post by a94060 »

try writing the code,if it does not work,post it up here and people will check it out. We cant write the whole thing out for you.
Post Reply