MYSQL - is this possible

[Decode]

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

http://www.tehupload.com/uploads/56561dff5ff9747help.png

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 :P

+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 :P

EDIT: I think you have mistaken columns for rows ;)

[wsg14]

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

[Tomm]

Use a INNER JOIN.

[Protege]

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

http://www.tehupload.com/uploads/56561dff5ff9747help.png

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 :P

+Rep for any help :)

Thanks.

For table one you should have multi rows so

ID (Article ID)
UserID (The users ID, thats it)

$query = mysql_query( "SELECT * FROM `table1` WHERE `ID` = '213'" );

$peopleVoted = mysql_num_rows( $query );

$f = mysql_fetch_array( $query );

$query_2 = mysql_query( "SELECT * FROM `table2` WHERE `ID` = '" . $f[ 'ID' ] . "' LIMIT 1" );

$r = mysql_fetch_array( $query_2 );

I dont really get it but thats how I see it.