Re: Simple data, simple query giving me a brain-ache

2009-02-15 Thread michael
) { > print $row->{first_name}; > print $row->{last_name}; > } > > then you could use select * from table_name without any problem. > > Octavian > > ----- Original Message ----- > From: > To: "MySQL General List" > Sent: Saturday, February 14, 2009 3

Re: Simple data, simple query giving me a brain-ache

2009-02-13 Thread michael
I'm a SQL novice, and I'v been looking at this, and I know I shouldn't, but I was 'Thinking'; Why wouldn't you do the following? SELECT * from HowToExample ORDER BY Ranking; Just curious, Michael. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Simple data, simple query giving me a brain-ache

2009-02-13 Thread Baron Schwartz
Timothy, On Fri, Feb 13, 2009 at 4:45 PM, Little, Timothy wrote: > Ok, I have a select statement which must return the distinct names, > sorted by ranking (lowest to highest). > > Seems absurdly simple, right, and I'm sure it would be... look at this > example > > CREATE TABLE IF NOT EXISTS HowTo