|
<html>
<head>
<title>Pregled</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<h1>PREGLED</h1>
<hr>
<a href="unos.php">Dodaj stavku</a>
<hr>
<?php
include "db_connect.php";
$sql="SELECT tabela1.kolona1, tabela2.kolona2 FROM tabela1, tabela2 WHERE tabela1.kolona1 = tabela2.kolona1";
if (!$q=mysql_query($sql))
{
echo "greska pri upitu<br>".mysql_query();
die();
}
if (mysql_num_rows($q)==0)
{
echo "Nema nista";
} else {
?>
<table align="center" width="500" border="1" cellpadding="5" cellspacing="0">
<tr>
<td align="center"><b>RB</b></td>
<td align="center"><b>KOLONA 1</b></td>
<td align="center"><b>KOLONA 2</b></td>
</tr>
<?php
$num_rows = mysql_num_rows($q);
while ($redak=mysql_fetch_array($q, MYSQL_ASSOC))
{
?>
<tr>
<td align="center">
<?php
echo $num_rows;
?>
</td>
<td align="right"><?php echo"{$redak['kolona1']}" ?></td>
<td align="left"><?php echo"{$redak['kolona2']}" ?></td>
</tr>
<?php
}
?>
</table>
<?php
}
?>
</body>
</html>
Ovo je kod i umjesto $num_rows treba da mi ispisuje redni broj reda a ne ukupan broj redova ali kako
Hvala
|
