Page 1 of 1

simple help needed updating records

Posted: Sun Feb 05, 2006 10:40 am
by jasondavis
Jcart | Please use

Code: Select all

and

Code: Select all

tags where appropriate when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]


Hi how can I make the below code work?

[b]This works[/b]

Code: Select all

$query = "UPDATE payed_users SET email = '" . addslashes($_POST['email']) . "' WHERE MSid = '" . $_POST['MSid'] . "'";
$res = mysql_query($query) or die("ERROR: " . mysql_error());

This doesnt

Code: Select all

$query = "UPDATE payed_users SET email = '" . addslashes($_POST['email']) . "' WHERE MSid = '" . $_POST['MSid'] . "'";
$query = "UPDATE payed_users SET startdate = '" . addslashes($_POST['startdate']) . "' WHERE MSid = '" . $_POST['MSid'] . "'";
$query = "UPDATE payed_users SET enddate = '" . addslashes($_POST['enddate']) . "' WHERE MSid = '" . $_POST['MSid'] . "'";
$query = "UPDATE payed_users SET amount = '" . addslashes($_POST['notes']) . "' WHERE MSid = '" . $_POST['MSid'] . "'"
$res = mysql_query($query) or die("ERROR: " . mysql_error());

Jcart | Please use

Code: Select all

and

Code: Select all

tags where appropriate when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]

Posted: Sun Feb 05, 2006 12:36 pm
by jwalsh
You are defining 4 queries, but only running the last one.

Posted: Sun Feb 05, 2006 1:40 pm
by raghavan20

Code: Select all

$query = "update `table_name` set `field_name` = 'field_value';";
$query .= "update `table_name2` set `field_name2` = 'field_value2';";
$query .= "update `table_name3` set `field_name3` = 'field_value3';";
$query .= "update `table_name4` set `field_name4` = 'field_value4';";
mysql_query($query); //this would execute four update statements in a row

Posted: Sun Feb 05, 2006 1:49 pm
by feyd
last I checked, mysql_query() did not support multi-query. Only mysqli's version does.