MYSQL - is this possible

[Decode]

For a database I have 2 tables setup, they are like-



I need to order the first table by num (SELECT * FROM `table1` ORDER BY `num` DESC) then I need to match the ID of that to the id in table 2. And it probs needs to be done in 1 mysql query because it needs to be used with mysql_fetch_assoc().

Sorry if what I've said is confusing. I have tried my best to explain it

+Rep for any help

Thanks.

[wsg14]

Why not add it all into one table instead of two?

[Decode]

What I have shown there is a simplyfied example, there is more than 1 of table 1. I am just explaining what the problem is with 2 tables.

[Source]

It would be better to have it all in 1 table, it wouldn't affect the speed of the site/query. Honestly.

[wsg14]

nevermind.

[Doritos]

You can access other things in other tables by table.field, if you didn't already know that.

[Decode]

It would be better to have it all in 1 table, it wouldn't affect the speed of the site/query. Honestly.

How many rows would there need to be before it starts effecting the speed of my site?

[wsg14]

How many rows would there need to be before it starts effecting the speed of my site?

I have about 20 rows in my users table, it works fine. You also don't have to worry about speed when all you have is around 7/8 rows.

[Decode]

I have about 20 rows in my users table, it works fine. You also don't have to worry about speed when all you have is around 7/8 rows.

Where do u get 7/8 rows from lol, I am hoping I will have lots more than that

EDIT: I think you have mistaken columns for rows

[wsg14]

I got it from your diagram, how many rows do you expect to have?