simple help needed updating records

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jasondavis
Forum Commoner
Posts: 60
Joined: Sat Feb 04, 2006 5:35 pm

simple help needed updating records

Post 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]
User avatar
jwalsh
Forum Contributor
Posts: 202
Joined: Sat Jan 03, 2004 4:55 pm
Location: Cleveland, OH

Post by jwalsh »

You are defining 4 queries, but only running the last one.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

last I checked, mysql_query() did not support multi-query. Only mysqli's version does.
Post Reply