[ slobodanka @ 01.03.2013. 23:11 ] @
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'");
}
[ MarkoBalkan @ 02.03.2013. 20:15 ] @
Citat:
slobodanka: 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'");
}


zašto starost oglasa držiš u bazi?
u bazu stavi datum kreiranja oglasa, a kod prikazivanja oglasa računaj starost.