Yep another question - MySql 2 tables

[Lamez]

how can I pull info from one table, then pull more info from another table?

 

in my db, I have  a table called users, that has all the info for users, then another one called active_users, that tells all the users that online

 

well how can I pull the user name and timestamp from active_users, then pull the e-mail from users?

 

I think I would use inner join or something like that.

[Barand]

see

http://www.w3schools.com/sql/sql_join.asp

[Lamez]

so is this right, if I want the username from one table, and email from another?

 

SELECT username, timestamp
FROM active_users
INNER JOIN users
ON active_users.username = users.email

 

in MySQL

$q = "SELECT username, timestamp "
."FROM".TBL_ACTIVE_USERS. "INNER JOIN".TBL_USERS."ON" .TBL_ACTIVE_USERS.username = .TBL_USERS.email "ORDER BY" timestamp DESC,username

[Lamez]

is that right?

[Barand]

If you echo $q you'll find most of it is all one word - you haven't left any spaces.

 

I can't verify the query logic without knowing your table structure and keys. Try running it, you won't do any damage with a SELECT query.