mysql_delete_row Function

mysql_delete_row - Delete row(s) in MySQL Table.

Syntax

string mysql_delete_row ( string table_name, array condition)

Parameter

table_name

Name of the table where data is needed to be inserted.

Input Example: "table_name"

condition

Condition that you want to be:

Input Example: $condition["field_name"]["eq"] = "name";

Which means delete rows whose value of field is equal to string name i.e field_name = "name"

Other functions for conditions where eq can be replaced with:

eq - Equivalent to =

neq - Equivalent to !=

gr - Equivalent to >

sm - Equivalent to <

gre - Equivalent to >=

sme - Equivalent to <=

li - Equivalent to LIKE

nli - Equivalent to NOT LIKE

lip - Equivalent to %LIKE%

libp - Equivalent to %LIKE

liap - Equivalent to LIKE%

nlip - Equivalent to NOT %LIKE%

nlibp - Equivalent to NOT%LIKE

nliap - Equivalent to NOT LIKE%

regex - Equivalent to REGEXP

nregex - Equivalent to NOT REGEXP

in - Equivalent to IN

nin - Equivalent to NOT IN

Error	Description
Error: No table ("table_name") or field ("field_name") exists.	Field entered in condition either does not exist or table_name entered does not exists

<?php

include("class.php");

$condition["field_name"]["eq"] = "Test";

mysql_delete_row("tablename", $condition); // Delete all items whose field "name" is equal to Test

No output would be displayed.

<?php

include("class.php");

$condition["field1"]["eq"] = "Test";

$condition["field2"]["eq"] = "Test2";

mysql_delete_row("tablename", $condition); // Delete all items whose field1 is equal to Test and also field2 is equal to Test2

No output would be displayed.