showing data from MySql

Anon

Helpers,

I want to show all the rows from a certain table. To do so I started a script.. First I have a $connection and $db from a general include.

Then I start a query to find all the data:

$sql = "SELECT *
FROM pagina, users
ORDER BY pagina_id DESC
";

$result = mysql_query($sql, $connection)
or die("Couldn't find record.");

Then I started the while to do all lines after ofcourse calling the header.

while ($row = mysql_fetch_array($result)) {
$begin = $row["begindatum"];
$pagina = $row["pagina_id"];
$kop = $row["kop"];
$plaats = $row["plaats"];
$naam = $row["auteur"];
$sqlnaam = "select *
from users
where User_id = '$naam'";
$naamresult = mysql_query($sqlnaam, $connection)
or die("oops");
$rij = mysql_fetch_array($naamresult);
$hehe = $rij["naam"];
$row_block_all = "
<tr>
<td>$pagina</td>
<td>$begin</td>
<td>$kop</td>
<td>$hehe</td>
<td>$plaats</td>
<td>
<a href=\"/tools/edit.php?id=$pagina_id\">edit</a></td>
</tr>
";

echo "
$row_block_all
";
}

If I now look at this page it shows all the rows 3 times ...

What am I doing wrong!!!!?????

Thanks

Peanuts

Anon

I think your query at the start is a join. Therefore your query may be selecting more data than you need. Try taking users out of the query and see what happens.

Anon

Nope :o(

That didn't make any difference (except that the name didn't work..)

But thanks I hope you have more Ideas

Greets

Peanuts

Anon

It's hard to follow what your doing. It's also time you learned about the list() command.

<?php
$sql = "SELECT p.begindatum, p.pagina_id, p.kop, p.plaats, u.naam FROM pagina p, user u WHERE u.User_id = p.auteur ORDER BY p.pagina_id DESC"
$result = mysql_query($sql);
while(list($begin,$pagina,$kop,$plaats,$naam) = mysql_fetch_row($result))
{
$row_block_all = "
<tr>
<td>$pagina</td>
<td>$begin</td>
<td>$kop</td>
<td>$naam</td>
<td>$plaats</td>
<td>
<a href=\"/tools/edit.php?id=$pagina_id\">edit</a></td>
</tr>
";

echo $row_block_all;
}
?>

Adapt to your needs and keep reading the manual.

---John Holmes...

Anon

Try running the query, "SELECT * FROM pagina, users;" from within mySQL. Does it give you each row three times?

If so, try "SELECT * FROM pagina;".

If you're still seeing each row three times, the problem is with the contents of the 'pagina' table. Otherwise the problem is with the join between 'pagina' and 'users'.

If "SELECT * FROM pagina, users;" works correctly (no repeated rows) from within mySQL, then the problem must be in your PHP code.

HTH,
Beth