Problem je sljedeci htio bi iz postojece tablice prepisat stupce u drugu tablicu ali samo ako je oznacena sa checkboxom ako mi moze neko pomoc gdje je problem
<?php
include("konfiguracija.php");
$tbl_name="baza1";
$tbl_name2="baza2";
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count = mysql_num_rows($result);
?>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<?php
// Dohvacanje iz baze sve inforamcije.
while($rows=mysql_fetch_array($result)){
?>
<form action="" method="post">
<tr>
<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td width="10%"><? echo $rows['id']; ?></td>
<td width="30%"><? echo $rows['ime']; ?></td>
<td width="30%"><? echo $rows['kolicina']; ?></td>
<td width="30%"><? echo $rows['cijena']; ?></td>
</tr>
<?php
// Zatvaranje while petlje
}
?>
</table>
<input name="submit" type="submit" value="Upis">
</form>
<?php
// Check if delete button active, start this
if(isset($_POST['submit'])){
for($i=0;$i<$count;$i++){
$idd = $checkbox[$i];
$sql = "INSERT INTO $tbl_name2 (ime, kolicina, cijena) SELECT ime, kolicina, cijena FROM $tbl_name WHERE id='$idd'";
$result = mysql_query($sql);
}
// Uspjeh
if($result){
echo "Uspjeh";
}
}
mysql_close();
?>