mysql_update_row Function

mysql_update_row - Update row(s) in MySQL Table.

Syntax

string mysql_update_row ( string table_name, array update_item, array condition)

Parameter	Description
table_name	Name of the table where data is needed to be inserted. Input Example: "table_name"
update_item	Items to be updated. Input Example: $update["field_name"] = "New Value";
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 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 or update_items either does not exist or table_name entered does not exists.

<?php

include("class.php");

$condition["field_name"]["eq"] = "Old Value";

$update["field_name"] = "New Value";

mysql_update_row("tablename", $update ,$condition); // Old Value would be updated to New Value

No output would be displayed.

<?php

include("class.php");

$condition["field_name_1"]["eq"] = "Some Value";

$update["field_name_2"] = "New Value";

mysql_update_row("tablename", $update ,$condition); // New Value would be updated in field_name_2.

No output would be displayed.