Solved

mysql Update a row with WHERE condition

Posted on 2010-08-14
3
315 Views
Last Modified: 2013-12-13
MySQL

How do I update all the columns in a row using the WHERE clause? the WHERE is equal to a php variable.

thanks.
0
Comment
Question by:Solutionabc
3 Comments
 
LVL 4

Expert Comment

by:philkeene
ID: 33437944
The UPDATE statement is used in the following way...

UPDATE mytable SET myfield = 'newvalue' WHERE myotherfield = 'a value'

... if you need to update all rows, simply miss off from WHERE onwards.

... hope this helps...
0
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 125 total points
ID: 33437977
hi,

Pass the variables:

  $var1 = $_POST['var1'];
  $var3 = $_POST[var3 ];
  $var3 = $_POST[var3 ];
  $var3 = $_POST[var3 ];
  $var3 = $_POST[var3 ];
  $someid = $_POST[someid ];

etc,
etc

then the update code:

$query = "update tablename" set field1='$var1,field2='$var2',field3='$var3,field4='$var4 where id='$someId" ;
      $result = mysql_query($query);' " ;

Something like this.

If you have more questions or if you want to attempt it and post the code, please do so
0
 
LVL 4

Assisted Solution

by:thor_victor
thor_victor earned 125 total points
ID: 33438736
Both are right. But....

UPDATE table SET field1 = 'var1', field2 = 'var2' WHERE field3 = 'var3';

i WOULD ADD = LIMIT 1 (or the number of spected rows to be changed cuz in a simple error, you could affect all rows)

UPDATE table SET field1 = 'var1', field2 = 'var2' WHERE field3 = 'var3' LIMIT 1;
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Making API calls from hashed passwords 26 52
php function to remove a file 31 39
ebay devID, appID, certID, userToken 2 24
ignore other .htaccess 2 43
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now