) {
> 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
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:
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
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 HowToExample
( Name VARCHAR( 32 ),
Ranking INTEGER )
ENGINE=MyISAM;
IN
