SELECT from more tables

[V]

Is it possible to echo out data from 2 tables but without making 2 loops and queries?

 

The code I use now is

 

$sql = "SELECT * FROM posts ORDER BY post_id DESC";

 

Can I combine it with..

 

$sql = "SELECT * FROM categories ORDER BY cat_id DESC";

 

..and define vars for both in one "while" loop?

[robert_gsfame]

Sure you can, use JOIN

 

for example: SELECT table1.*,table2.* FROM table1 JOIN table2 ON table1.username=table2.username WHERE blabla

 

then get the array result

 

 

[V]

Very cool! That's much better than what I used to do THanks!