Topic: su delete proble
Taigi naudoju siuos skriptus failu trinimui. Paspaudus delete, man paraso "Rows deleted" atrodo kaip ir viskas tvarkoje ir istryne, bet paziuriu i duomenu baze jie buna neistrinti. Galbut esate susidure su kazkuom panasaus ir galbut zinot kur galetu buti problema? Viska sutikrinau keleta kartu ir niekaip nerandu priezasties.
Lentele rusis:
rusis_id
rusis_pav
tipas_id
Pirmas failas
<?php
$host = "xxx";
$user = "xxx";
$password = "xxx";
$database = "xxx";
mysql_connect($host, $user, $password) or die("Nesijungia prie MySQL: " . mysql_error());
mysql_select_db($database) or die("Nëra tokios duombazës: " . mysql_error());
mysql_query("SET NAMES CP1257");
if(!isset($cmd))
{
$result = mysql_query("select * from rusis order by rusis_id");
while($r=mysql_fetch_array($result))
{
$rusis_pav=$r["rusis_pav"];
$rusis_id=$r["rusis_id"];
echo "<a href='delete.php?cmd=delete&rusis_id=$rusis_id'>$rusis_pav - Delete</a>";
echo "<br>";
}
}
?>
Antras
<?
$host = "xxx";
$user = "xxx";
$password = "xxx";
$database = "xxx";
mysql_connect($host, $user, $password) or die("Nesijungia prie MySQL: " . mysql_error());
mysql_select_db($database) or die("Nëra tokios duombazës: " . mysql_error());
mysql_query("SET NAMES CP1257");
if($_GET["cmd"]=="delete")
{
$sql = "DELETE FROM rusis WHERE rusis_id=$rusis_id";
$result = mysql_query($sql);
echo "Row deleted!";
}
?>