[Resolved] Simple question: table relations

[sapoxgn]

I m making a news system and having some problems with the tables... i have this:

$query_not = sprintf("SELECT * FROM noticia ORDER BY data DESC LIMIT $max_itens");
	$not = mysql_query($query_not) or die(mysql_error());
	$totalRows_php = mysql_num_rows($not);

while ($row_not = mysql_fetch_assoc($not);

//news code

now i need to get the id of the user who posted the news from the news table and print the name and e-mail from the users table...

how do i do it?

im lost because there´s a loop and for each new i have and different user

thanx for any help
😕

[thorpe]

is there anything relating these tables?

this 'now i need to get the id of the user who posted the news from the news table and print the name and e-mail from the users table...'

doesnt really make much sense. could you show us what your tables look like and what info you want from each?

there is only two tables you want to join right?

i mean you mention 3 in your post. noticia, news, and users.

[sapoxgn]

thanx for helping... i ve found a code in the database section and now its working, i was trying to make 2 querys one for each table.. now i have this:

$query_not = sprintf("SELECT noticia.*, autor.nome, autor.email FROM noticia, autor WHERE noticia.autor=autor.codigo ORDER BY noticia.data DESC LIMIT $max_itens");

i just have 2 tables noticia = news 😃

and the row autor is relating the noticia and autor tables 🙂

btw, thanx for replying 😃