I spent more of whole day to find solution but it not working as i want it.
I have some tables with different column names. I want to did it with one SELECT and continuos IF.
I tried different ways, but aways got error with $row=mysql_fetch_assoc($rs);
It got work only with alias, but i want to show more than one results from each table, but this code shown only by one result from each table.
- Code: Select all
$rs = run_q("SELECT a.*, b.* FROM posts as a, nwo as b ORDER BY a.datetime , b.datetime DESC LIMIT 4");
nwo and posts are my tables
All other methods which i tried as JOIN or UNION and some more didnt work for me.
Where is the problem? It is in the SELECT line or with the continues code?