[ 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'"); } |