query

**MrLister** · Jun 10, 2001, 11:55

here's what i have currently

PHP Code:


$result = mysql_query("select cheat_name, cheat_id, cheat_text, cheat_cat from cheats_pc");

at the end of from cheats_pc i want to add something so it only selects all where cheat_name starts with a and it does it in alphabetical order.

**CrazyCrane** · Jun 10, 2001, 11:59

Code:

select cheat_name, cheat_id, cheat_text, cheat_cat from cheats_pc where cheat_name like 'a%' order by cheat_name asc

(I think that's the right syntax, don't shoot me if it's not...)

**MrLister** · Jun 10, 2001, 12:06

yup that worked. thank you!

**CrazyCrane** · Jun 10, 2001, 12:09

No problem

The SitePoint Forums have moved.