sort problem

Anon

i have tables as follow:
CREATE TABLE auth
(
id int not null auto_increment,
primary key (id),
username varchar(20) binary,
rank char(3),
);

CREATE TABLE public
(
id int not null auto_increment,
primary key (id),
gender varchar(6),

);

i am trying to get php to list the top 100 ranked males and also the same thing for females.
i am trying SELECT auth.username, auth.rank, auth.votes, public.age FROM public as public, auth as auth WHERE gender='Male' and i can't even get it to select only the males? any advice?

Anon

SQL:

public.gender='male' may help.

Why is auth.rank data format = char(3)?? If you are looking for top 100 ranked, you may need to change it to Interger so that you can compare.

What type of data goes into the auth.rank field?

To display the first 100, (SQL)

order by auth.rank asc limit 0,100

-> order by auth.rank field in ascending order from 0 to record 100.

Kai

Anon

i have a question about the tables relation,
are u going to use id as a key to join this 2 tables?
but u didn't show this in the sql statment.
i think u can try this:
select * from public as p left join auth as a on p.id = a.id order by a.rank desc limit 100

if u wanna to do this, there also have another question. As u use auto increment as primary key in these 2 tables, How to do mapping between these 2 tables? I think 1 table should not to use auto increment.

hope it's helpful.