hocu da menjam kolonu u tabeli i da je takvu prikazujem i po potrebi kasnije brisem vrste
dakle tabelu prikazujem na sledeci nacin
$result = mysql_query("SELECT * FROM auto");
echo "<table border='1'>
<tr>
<th>R.Br.</th>
<th>Ime</th>
<th>Prezime</th>
<th>Telefon</th>
<th>Oglas</th>
<th>Vreme unosa</th>
<th>Starost oglasa</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['rbr'] . "</td>";
echo "<td>" . $row['ime'] . "</td>";
echo "<td>" . $row['prezime'] . "</td>";
echo "<td>" . $row['tel'] . "</td>";
echo "<td>" . $row['tekst'] . "</td>";
echo "<td>" . $row['vreme'] . "</td>";
echo "<td>" . $row['starost'] . "</td>";
echo "</tr>";
}
echo "</table>";
kako da napravim Ok update kolone starost
evo mog pogresnog koda
$result = mysql_query("SELECT * FROM auto");
while($row = mysql_fetch_array($result))
{
$starost = (time()-$row['vreme'])/86400; //racuna broj dana
mysql_query("UPDATE auto SET starost= '$starost'");
}