delete from tabula

[Klez]

vai no tabulas ir iespeejams ar vienu query izdzeest vairaakus ierakstus peec ID

DB = mysql 4.0.23

ID tabulaa ir int autoIncrement

 

id | val

1 a

2 b

3 dd

4 ff

 

gribu izdzeest 1 un 3 ierakstu ar vienu query. bet zinaams ir tikai ieraksta ID

 

ir tas paveicams?

[Venom]

DELETE FROM tabula WHERE id IN(1,3)

NB: ja ģenerē att. checkbox-inpututus

 

while (...fetch...)

<input type="checkbox" name="todelete[]" value=" $id " />

 

tad var ērti izmantot

 

'DELETE FROM tabula WHERE id IN('. implode(',', $_POST['todelete']).')'

 

variantu

[Klez]

'DELETE FROM tabula WHERE id IN('.  implode(',', $_POST['todelete']).')'

13695[/snapback]

 

shis baigi laps varinats. To arii vajadzeeja. paldies :)

[bubu]

Klez, tik atceries: neuzticies lietotāja datiem!!!

Pirms laid to implode uz $_POST masīva elementu, izej viņam cauri un pārliecinies, ka visas vērtības ir integer!

DELETE FROM tabula WHERE id IN('.  implode(',', array_map("intval", $_POST['todelete'])).')'

Edited February 14, 2005 by bubu