Hallo allemaal
Ik ben bezig met een scriptje waarmee ik bepaalde records kan toevoegen, wijzigen en verwijderen.
Het probleem is dat als ik een rij selecteer dan krijg ik niet die specifieke rij maar gelijk alle rijen te zien uit de database. Ik heb bijvoorbeeld op de index pagina tabel 1 en tabel 2, ik klik dan op tabel 1 om hem te wijzigen en ik wordt doorgeschakeld naar wijzigen.php. Nu moet ik eigenlijk alleen tabel 1 krijgen maar ik krijg ook tabel 2 en dat is dus het probleem.
Hieronder het script:
<?
require('database.php');
$query = "SELECT * FROM info";
$sql = mysql_query("$query");
while ($fill = mysql_fetch_array($sql)) {
$id = $fill['id_rel'];
$ftp = $fill['ftp'];
$ftp_user = $fill['ftp_user'];
$ftp_pass = $fill['ftp_pass'];
$database = $fill['db'];
$db_user = $fill['db_user'];
$db_pass = $fill['db_pass'];
$admin_shop = $fill['admin_shop'];
$shop_user = $fill['shop_user'];
$shop_pass = $fill['shop_pass'];
$admin_website = $fill['admin_website'];
$admin_user = $fill['admin_user'];
$admin_pass = $fill['admin_pass'];
?>
<form>
<table width="291" border="0" cellpadding="0" cellspacing="1" bordercolor="#999999">
<tr>
<td width="138"><span class="style1">FTP</span></td>
<td width="150"><input type="text" name="FTP" value="<? echo "$ftp"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">FTP User </span></td>
<td><input type="text" name="FTP_USER" value="<? echo "$ftp_user"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">FTP Password</span></td>
<td><input type="text" name="FTP_PASS" value="<? echo "$ftp_pass"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Database</span></td>
<td><input type="text" name="DB" value="<? echo "$database"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Db User</span></td>
<td><input type="text" name="DB_USER" value="<? echo "$db_user"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Db Password</span></td>
<td><input type="text" name="DB_PASS" value="<? echo "$db_pass"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Admin Winkel </span></td>
<td><input type="text" name="ADMIN_SHOP" value="<? echo "$admin_shop"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Winkel User</span></td>
<td><input type="text" name="SHOP_USER" value="<? echo "$shop_user"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Winkel Password</span></td>
<td><input type="text" name="SHOP_PASS" value="<? echo "$shop_pass"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Admin website</span></td>
<td><input type="text" name="ADMIN_WEBSITE" value="<? echo "$admin_website"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Admin User </span></td>
<td><input type="text" name="ADMIN_USER" value="<? echo "$admin_user"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style1">Admin Password</span></td>
<td><input type="text" name="ADMIN_PASS" value="<? echo "$admin_pass"; ?>" size="25" ></td>
</tr>
<tr>
<td><span class="style2"><? echo "$id" ?></span></td>
<td><input type="submit" name="Opslaan" value="save" style=" WIDTH:120PX; "></td>
</tr>
</table>
</form>
<?
}
if(isset($Opslaan))
{
mysql_query("update info SET ftp='$FTP', ftp_user='$FTP_USER', ftp_pass='$FTP_PASS', db='$DB', db_user='$DB_USER', db_pass='$DB_PASS', admin_shop='$ADMIN_SHOP', shop_user='$SHOP_USER', shop_pass='$SHOP_PASS', admin_website='$ADMIN_WEBSITE', admin_user='$ADMIN_USER', admin_pass='$ADMIN_PASS' where id_rel='$ID_REL' ");
?>
<script>
location.href="index.php";
</script>
<?
}
?>
wie o wie kan me helpen
alvast bedankt
1.803 views