join syntax

Anon

Ok, here's my problem.

I am creating a php-based online newspaper.
I have made categories, and all those sites are done (the /sport /etc) and so on, but, on the main page, and in an archive page i want to get the newest articles (i've got the timestamp) from all the different categories. My categories are all made in different tables (sport,news,culture) and so on. I have tried a normal select query, with select column.table1, column.table2 and so on, but it wouldn't work. I got an advise, which was to use a join syntax. I've read about it on mysql.com, but i am not sure that i can figure it out properly. Anyone help me with this ? Maybe create the syntax for me ? Any help would be appriciated. I want to get 3 columns from each table, "id", "ingress", and "tittel". (norwegian language 🙂. Thank you!

Jone.

Anon

I'd suggest you use PostgreSQL if you're looking for an Open Source, free RDBMS -- MySQL is crippled in it's abilities here (it can do joins, just not very many other things).. You need a RDBMS for your application, not a SQL interface to the filesystem (MySQL).

Basic join syntax :

SELECT * FROM table1 as t1 table2 as t2 WHERE t1.id=t2.id

You get the idea, I hope..

Anon

I have read that one, like i said in my first statement. But i just can't make it work, can anyone make the syntax for this :

I want to get 3 fields, from 2 tables, tables are sport,nyheter. They have different numbers of rows. I want to order them by field : oppdatert (which is a timestamp), so it shows all the records in both tables with the fields when i put this in a while syntax. The fields are ;oppdatert, ingress, tittel . I want to order them by oppdatert. Anyone help ? Please.
Thank you.

en0j