I need help. I have done this:

$sql = "SELECT jedan.ime, jedan.text, dva.rb, dva.opis, dva.proizvod,
dva.sifra, dva.cijena
from jedan, dva WHERE jedan.ime=dva.ime ";
$result = mysql_query($sql,$link) or die("ERROR IN
QUERY:".$sql."<br>".mysql_error());
while($row = mysql_fetch_array($result))
{
include "show.php";
}


and show.php is:

table>
<tr>
<td><?= $row["ime"]?></td>
<td><?= $row["text"]?></td>
</tr>
<tr>
<td><?= $row["rb"]?></td>
<td<?= $row["opis"]?></td>
<td><?= $row["proizvod"]?></td>
<td><?= $row["sifra"]?></td>
<td><?= $row["cijena"]?></td>
</tr>
</table

The problem is in row ime and text. I have to get something like this:

Ime1 Text1
1. rb opis proizvod sifra cijena
2. rb opis proizvod sifra cijena
....

Ime2 Text2
1. rb opis proizvod sifra cijena
2. rb opis proizvod sifra cijena

but i got:

Ime1 Text1
1. rb opis proizvod sifra cijena
Ime1 Text1
2. rb opis proizvod sifra cijena
....

Please help...
tnx

stjepko wrote:
> I need help. I have done this:
>
> $sql = "SELECT jedan.ime, jedan.text, dva.rb, dva.opis, dva.proizvod,
> dva.sifra, dva.cijena
> from jedan, dva WHERE jedan.ime=dva.ime ";
> $result = mysql_query($sql,$link) or die("ERROR IN
> QUERY:".$sql."<br>".mysql_error());
> while($row = mysql_fetch_array($result))
> {
> include "show.php";
> }
>
>
> and show.php is:
>
> table>
> <tr>
> <td><?= $row["ime"]?></td>
> <td><?= $row["text"]?></td>
> </tr>
> <tr>
> <td><?= $row["rb"]?></td>
> <td<?= $row["opis"]?></td>
> <td><?= $row["proizvod"]?></td>
> <td><?= $row["sifra"]?></td>
> <td><?= $row["cijena"]?></td>
> </tr>
> </table
>
> The problem is in row ime and text. I have to get something like this:
>
> Ime1 Text1
> 1. rb opis proizvod sifra cijena
> 2. rb opis proizvod sifra cijena
> ...
>
> Ime2 Text2
> 1. rb opis proizvod sifra cijena
> 2. rb opis proizvod sifra cijena
>
> but i got:
>
> Ime1 Text1
> 1. rb opis proizvod sifra cijena
> Ime1 Text1
> 2. rb opis proizvod sifra cijena
> ...
>
> Please help...
> tnx
>
>
It should be a simple fixup:
change the line 'include show.php' to
if($row["ime"]!=$old_ime || $row["text"]!=$old_text) {
include show1.php;
$old_ime = $row["ime"];
$old_text = $row["text"];
}
include show2.php

With show1 and show2 being the approptiate parts of show.

that is it!

tnx Bob