[Resolved] querying 3 tables

[qrt123]

In short:

I have problems with making a query in 3 tables.

When making a query in just the 2 of them, there is no problem, but adding the 3. table, then everything goes wrong.

here is the code so far.:

$foresp = mysql_query("SELECT users.id, users.navn, products.id, products.navn, poll.id, poll.productid, poll.vote FROM musers, products, poll WHERE musers.navn='$user' AND poll.produktid=products.id");
while($data = mysql_fetch_array($foresp)){

echo "<table border=0><tr>";
echo"<td>". $data[3]."</td>";
echo"<td>". $data[7]."</td>";
echo"<td>". $data[1]."</td>";
echo "</tr></table>";

}

If I remove everything concerning the poll-table it works.
But that is not the purpose ;-).
The polltable looks like this:

id - key
userid
productid
vote

You know what I mean?

Hope someone can help me here.
Thanks

[Dvector]

I can see one thing to start with. You say your poll table is built like:

id - key
userid
productid
vote

But your SQL statement query has a typo near the "where poll.produktid", which I would think should be poll.productid 🙂

[qrt123]

Dvector

Thanks for your reply.
My typingerror.

produktid is infact productsid.
An error here in the thread and not in the script.

Sorry.

[qrt123]

Ooops.

I really made an error here.
I solved it myself, only by doubble checking my own typing.
How blind can one get???
lol ;-)

Sorry