Array Update

Feb 3, 2003

If I want to update a part of an array, do I need to rebuild the array or can I just specify a new value for the key? PHP Code:

ADVERTISEMENT

Store Form Data In An Array And Update Array With Each Submit Click?

Apr 18, 2011

i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far.

View 2 Replies View Related

Update Values In An Associative Array And Store The Entire Array?

Mar 11, 2010

Here's a code example:

$array = array();
$array['master']['slave'] = "foo";
foreach ($array as $key => $value) {
foreach ($value as $key2 => $value2) {

[Code]....

Output does not reflect 'foobar' in l5

View 4 Replies View Related

Update Array

Nov 12, 2007

I am trying to update my a table on my DB using update and an array i have the following funtion that i found on the net but i dont understand how to use it could anyone help?

function mysql_update_array($table, $data, $id_field, $id_value) {
foreach ($data as $field=>$value) {
$fields[] = sprintf("`%s` = '%s'", $field, mysql_real_escape_string($value));
}
$field_list = join(',', $fields);

$query = sprintf("UPDATE `%s` SET %s WHERE `%s` = %s", $table, $field_list, $id_field, intval($id_value));

return $query;
}

or if you have any other ways that are easy to do then the above i would love to hear about them.

View 2 Replies View Related

Form -> Array -> Update

Jan 30, 2003

I have a form which lifts 20 items at a time out of a db table. Against each record I place a textbox for suggested changes, and the relevant line in the form is: PHP Code:

View 6 Replies View Related

Array To Update A Table.

Jan 27, 2007

What I'm trying to do is pull a couple variables off a table. Then update some variables and upload them to the server. Code:

View 7 Replies View Related

How To Update Associative Array

Nov 13, 2006

I am working on my first online shop system and would like help with the following:

when a user adds items to the basket, I store the data in a session variable

$_SESSION['mybasket'][$_POST['productid']] = array('quantity' => $_POST['quantity'], 'productprice' => $_POST['productprice']);

Now, in my Basket View page, I want to allow the user to update the quantities as you would expect of each item if they choose to do so, but this is where I am stuck.

For each product item in my array I echo the product details but also a Quantity Field as such: PHP Code:

View 5 Replies View Related

Update Specific Value In Array?

Jul 9, 2011

I have the following array, $cart which is structured like so:

Array
(
[0] => Array
(
[sku] => TEST1
[size] => s
[qty] => 1
)
)

how can I update the qty to 2 directly using php and not using a foreach loop (nb. assume I have the index value (0) already).

View 2 Replies View Related

MongoDB: Update A Value In An Array?

Dec 17, 2010

I have the following mongodb object:

{
"_id": ObjectId("4d0b9c7a8b012fe287547157"),
"messages": {
"0": {
"toUname": "Eamorr3",

[Code]....

Do I need to pull the entire array element, modify and and push it back in again?

View 2 Replies View Related

UPDATE On An Array Resultset?

Jun 16, 2009

i have a small issue on a site that i maintain, basically its a costing report for a given user between two dates, it seemed to be working fine, but we have just noticed somethin weired: we put our start and end dates in and we get the correct results back with textboxes to amend the $value if we need to, the problem comes when we submit any changes, and the code does its stuff. history.value has a default of 3.10 $value properties are:

Quote:
value | decimal(3,2) | No | 3.10
Heres the page code:
$sql="SELECT * FROM history, property WHERE history.property_id = property.property_id AND history.user_id = '$client' AND history.updated >= '$start' AND history.updated <= '$end'";
$result=mysql_query($sql);

[Code]...

As you can see its putting in the default, but spread over the first four UPDATES then updating the remaining $value's as blanks. im assuming the array is messed up, but i cannot work out why.

View 14 Replies View Related

Update A Multi-array Value?

Apr 20, 2011

I have this multidimension array in which I need to update a value. What would be the best way to do so? I tried it with 2 foreach loops but wasn't sure if that was the right approach.

Here is the array in question. I need to update the dollar amount on each sub array (i.e. add 3 to it).

array(6) { ["Ground"]=> array(2) { [0]=> string(3) "USD" [1]=> string(5) "13.63" }
["3 Day Select"]=> array(2) { [0]=> string(3) "USD" [1]=> string(5) "25.26" }
["2nd Day Air"]=> array(2) { [0]=> string(3) "USD" [1]=> string(5) "32.43" }
["Next Day Air Saver"]=> array(2) { [0]=> string(3) "USD" [1]=> string(5) "63.00" }
["Next Day Air"]=> array(2) { [0]=> string(3) "USD" [1]=> string(5) "68.65" }
["Next Day Air Early AM"]=> array(2) { [0]=> string(3) "USD" [1]=> string(6) "103.68" } }

View 4 Replies View Related

Update Record Using Array?

Nov 9, 2009

I receive the error "update has failed 1054: Unknown column 'Array' in 'field list'" Why does it think that there is a column called 'Array'?I am updating multiple records in my database using php. There may be one or five records updated at a time, so I am using FOREACH (that's what I used when I first inserted them into the database). Once the record is selected, the form is repopulated with the old values, and the user may change them.(new values are assigned to variables beginning with "ud_"The form

PHP Code:<TD><input type="hidden" name="match_activity_id[]" value="<?php echo $match_activity_id; ?>"/><?php echo $match_activity_id; ?></TD>
[code]..

I receive the error "update has failed - 1054: Unknown column 'Array' in 'field list'" Why does it think that there is a column called 'Array'? I've eliminated many other variables from the example to shorten this post. I hope that I did not leave out anything important amount the copying/pasting.When I rint_r($POST) I receive the first row[0] (there was only one record being updated): rray [match_activity_id] => Array ( [0] => 16 ) [ud_invoice_number] => Array ( [0] => 7 ) [ud_code_id] => Array ( [0] => 7 ) [ud_contributor] => Array ( [0] => County))All of the values are correct, by the way. I hope this post isn't too long and confusing.

View 8 Replies View Related

Update Record Using Array?

Sep 27, 2010

Im having some trouble trying to update my table using an array, It processes and doesnt throw up any errors so im at a loss as to whats happening as its not updating my table?

my page is Code: [Select]mysql_select_db($database_saucy_connection, $saucy_connection);
$query_allphotos = "SELECT * FROM model_login, model_pictures WHERE model_pictures.user_id=model_login.id";
$allphotos = mysql_query($query_allphotos, $saucy_connection) or die(mysql_error());
$row_allphotos = mysql_fetch_assoc($allphotos);
$totalRows_allphotos = mysql_num_rows($allphotos);

[Code]...

View 4 Replies View Related

How To Update Array Values

Nov 3, 2010

I'm trying to figure out how to update values I have in an array. I've read about all sorts of bits but I'm stuck, I dont really understand associative so thought I'd post an example of my code for someone to hopefully assist.. so, if I have a table $fees, which is filled from a select, for example..

select * from `cases_fees`.     "contains fields for id, type, amount and others

now I want to do is foreach through that table and update a field called `amount`. but I cant understand the foreach >= as key part.  what is a key and what isn't ? (I know what the keys of the db table arem but that's not the same eh?)

I'm fine with normal foreach, but I cant update back to the array so I need to find out how to be able to set valus back into $fees[`amount`]

View 3 Replies View Related

Update The Content Of An Element In My Array

May 10, 2006

foreach ($consumers as $key => $consumer) {
if ($consumer ['transstatus'] == 'OK') {
$consumers [$key] ['transstatus']= "Payment Successful";
}
}

I am trying to update the content of an element in my array above. The consumers array contains the data is created by an sqlquery.

View 2 Replies View Related

Update Table From Array Values

Jun 10, 2005

I have a table with records and each record has a groupid, userid and a statusid. Where a status is a particular number within these records, I need to gather those groupid and userid into an array. Then i need to use the values in the array to update the same table with a new statusid. So, i basically need guidance on how to do this. This is what I have so far:

$sqlquery = "SELECT groupid, userid, statusid FROM mytable WHERE statusid = 1";
$result = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($result)) {
$myarray[] = $datarow[groupid];
$myarray[] = $datarow[userid];
}

View 1 Replies View Related

JQuery Update Array Into Javascript?

May 26, 2011

Simplified version of my problem: Here is javascript example called example.html writes the content of a javascript array.

[Code....]

Instead of array the values are written columns file.txt located in the same server directory where the example.html is. file.txt looks like that

1 2
3 4
5 6

I would like to accomplish the same functionality as the example above by reading this file with php and pass it to the javascript. file.txt is a log file where new values are being appended every few seconds So when new values are added I want to see the changes updated to screen. Here is getfile.php function that reads the file.

[Code....]

This code displays the file.txt. However when I manually append new values to the file.txt there is no update in the browser. If I refresh the page manually the new values are shown as well. So what am I doing wrong? Is it the php script or probably I am not using the setInterval() properly.

View 4 Replies View Related

Array: Rename Key And Update Values From A Given Key

Aug 20, 2010

I have the array:

[Code]....

1 - Change the key Branch to Brand, but without moving it to the end or the array.
2 - Update all the values to the key Country, changing Jpn to Japan

The result should be like this:

[Code]....

View 5 Replies View Related

Update Fields From An Array With CakePHP?

Jun 9, 2011

I have an array that is sent to my controller, such as this:

$array = array(
[0]=>array(
[id]=>5,
[position]=>6

[Code]....

And I need to save the position of each item using its id. What is the best way to do this in cakePHP? I can only imagine looping an update function or pulling the entire database, changing the correct values, then saving the database.

View 2 Replies View Related

MongoDB - Update Individual Value Of An Array?

Dec 17, 2010

I have the following mongodb object:

{
"_id": ObjectId("4d0b9c7a8b012fe287547157"),
"messages": {
"0": {
"toUname": "Eamorr3",

[Code]....

How do I set "read" to 1 in PHP?

Here's what I've tried sofar to no avail:

update(array('uname'=>$uname),array('$set'=>array('messages'=>array('read')=>'1')));

View 1 Replies View Related

Update Function With Array Of Authors?

Aug 12, 2010

I have the following code which basically checks an array of input textboxes and inserts them into a database table:

public function insertAuthor($authArray, $PCorder=0)
{
$query = sprintf('SELECT Pid, Pname FROM People WHERE Pname IN('%s') ORDER BY Pid ASC', implode('','', $authArray));
$result = mysql_query($query);

[Code]...

The logic works by firstly checking to see if an Author exists, if so they are inserted into PeopleCon, if not they are inserted into People AND PeopleCon. This all works perfectly. But now what  i need to do is build an update method where users can edit the authors also. The logic would be more or less the same, but i wouldn't neeed an insertpersons method, i would need to change it, and also the script would edit the existing authors, and if anymore are added apply the same method as above.

View 1 Replies View Related

UPDATE Table With Array When Submit?

May 30, 2011

I have the below code:

Code: [Select]<div>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td colspan="7" valign="top">

[Code].....

This pulls data in array from database for example:

test1;test9;test2;test3;test4;test5;test6;test14;test7;test8

The SELECT query works fine if i manually edit the array in the database to make the boxes checked or not.

Problem seems to be when i click submit, its not updating the DATABASE?!

i recently upgraded to PHP5 eventually and it seems it stopped working arond then.

View 1 Replies View Related

Update Database With Textbox Array W/ PEAR

Aug 10, 2004

I am having slight problems with trying to get my page to work properly. Right now i have a form which displays the information of the rows in the database through textboxes. I have two textbox arrays: name[] and price[].

first i connect to database...

if form was submitted it goes through this code:

View 1 Replies View Related

Abstracting The Update Method - Iterate Though The Array?

May 19, 2010

i want to do is instead of using static:: $arr[0].",".static:: $arr[1] i want to iterate though the array.. i tried using a foreach loop but it doesn't work.. i don't understand why..if someone demonstrate a code to do this in a better way.this is my code.

<?php
class MainModel {
public static function create($custArray){[code]....

View 5 Replies View Related

Using Form Variables To Update Array On Same Page?

Jul 5, 2009

I have a small app that displays the contents of a MySQL database table, and am trying to get a form at the top to work. Here is what I have - the app works fine, if the database info is input directly into the file,.. in an array like this:

Code:
"database" => array("host" => "localhost",
"username" => "user1",
"password" => "mypassword",
"database" => "test_db",
"table" => "myTable"),
"sortable"=> "all",

[Code]...

I'm no JS wiz, but I presume that AJAX might be a way to go when updating variables without leaving the page or sending the data to another page..

View 8 Replies View Related

Update An Array By Reference In A Foreach Loop?

Jun 8, 2009

In the code below, the idea is to update the $values array by the $value assigned reference variable.

PHP Code:
<?php
$str = 'value one, values, ';
$values = explode(',', $str));
print_r($values);
foreach($values as &$value)
{
if(!empty(trim($value))

[Code]...

What am I missing - because this does not work!

View 4 Replies View Related

Update Postgres Table With Array Elements?

Jul 8, 2011

I want update the Postgres database table with array elements but I didn't know how.

I tried this but I got this notice: Notice: Undefined index: 'value' in 'file' on line x

Update:

private function debug ($function_name, $arg_names, $arg_vals (<=with func_get_args()) )
{
$arg_names_array = explode(',', $arg_names);
foreach($arg_names_array as $k => $v)
{
$v = trim($v);

[Code]....

View 1 Replies View Related

Edit In Place With Javascript And Update Array Value?

May 30, 2011

I am not using any javascript plugin,

[code]...

When Double click on any cell Then enter your own text and then tab out or click on other place.so How can I update these data example store in an array ,can store values in every time edited?

View 1 Replies View Related

Update - MongoDB Delete Element From Array?

Dec 19, 2010

I have the following MongoDB object:

{
"_id": ObjectId("4d0e28938b012fe28754715a"),
[code].......

View 1 Replies View Related

Form Data Array - Need To Update Table

May 14, 2007

I have a form that is dynamically generated by the fields I have in a table. This table generates the navigation for my site, and I want to create a page that will allow me to reorder and hide/show and activate/deactivate the links. The form is working and I have the form generating an array based on the data collected on submit. I need to know how to break this data apart so I can update my site navigation table with the correct values. The table looks like this:

View 8 Replies View Related

Static Array Vs Mysql + XML File To Update Via Ajax?

Apr 6, 2011

I have five elements. Each elements have 5 colors and I have to retrieve the pictures that fits those colors.

Example:

Boot [Color1,Color2,Color3,Color5]
Shoes [Color1,Color2,Color3,Color5]

The first element have 28000 posibilities the others has less than 5000. Via ajax I will send the colors and It will return the picture. So Which is the best way to store data that are going to grow:

Static Array.
A PHP with a Mysql database.
Or a static XML file (it can weight 1MB).

View 3 Replies View Related

Update Multiple Keys In Array Representing Progressbars In Different Speeds?

Feb 17, 2011

i have 9 progress bars. generated from an array like this:

$progress = "100-30-0-0-0-0-0-0-0";
$array= explode("-", $progress );

I need to update the progress bar in different speeds. This is how I do it now:

if($array[0] >= 100){ $array[0] = 100; }else{ $array[0] = $array[0] + rand(3,8); }
if($array[0] >= 75){if($array[1] >= 100 ){ $array[1] = 100; }else{ $array[1] = $array[1] + rand(2,7); }}
if($array[1] >= 75){if($array[2] >= 100 ){ $array[2] = 100; }else{ $array[2] = $array[2] + rand(2,5); }}[code]....

This updates the first progress bar up to 75 %, 3 to 8% a the time before the next progress bar start increasing, in slower and slower rate. Now I need a loop to update an endless amount of progress bars in this way.

View 1 Replies View Related

Passing Array Into Javascript Through JSON To Update Google Chart

Nov 9, 2009

I have three PHP arrays that I've encoded with json... extra PHP code has been omitted because the arrays work properly.... Additionally, the HTML tags that call the google chart have been omitted for sake of brevity...

<?php
$encoded_line_volume = json_encode($LineVol) . "
";
$encoded_loan_volume = json_encode($LoanVol) . "
";
$encoded_cluster_name = json_encode($ClusterLine) . "
";
?>

I would like to access these three arrays in Javascript to update my Google Chart dynamically.

[Code]....

View 1 Replies View Related

MySQL UPDATE Query Using Field Names / Values From Array

Mar 20, 2011

Code: [Select]$insert= mysql_query   ("INSERT INTO tablename (column1,`".$EXPfields."`) VALUES ('$something','".$EXPvalues."')");
where $EXPfields is an array of table-field-names and $EXPvalues is an array of table-field-values.

Now I want to write an equivalent query, but using UPDATE instead of INSERT INTO, but I don't want to write out all the field names/values separately, but again want to use $EXPfields and $EXPvalues.

So something like this:
Code: [Select]$update = mysql_query ("UPDATE tablename
SET (column1,`".$EXPfields."`) = ('$something','".$EXPvalues."')
WHERE ....
");

View 6 Replies View Related

Make Unselected Checkbox Destroy Previous Array On Update?

Aug 2, 2010

I am using a WordPress theme that uses some of its own functions besides WP functions. when I say "Multiple Checkboxes" in the paragraphs below I am NOT talking about checkboxes that each hold a single value.  I am talking about one Checkbox field that allows multiple values to be selected and puts those values into an array with one Name value and stores the output in a string in a single mysql table field. Right up front, what I need during the Edit Ad functions is the inbuilt function that will Delete the previous Array of values in any multiple checkbox when the ad is updated. Right now updating the ad works for every situation except NO values selected or for Unchecking all previously selected values in a Multiple Checkbox.  If I have, for example, 4 checkboxes selected and unselect all of them before submitting the edited ad it will return the last saved array of values but not an Empty array with no checkboxes selected.

This theme has a Form Builder with a Custom fields builder used by the admin to create forms for a classified ads website. According to which category of ad the Ad creation procedure will show different forms, with different fields. I had to manually create the capability to generate multiple checkboxes...so that the different multiple checkboxes when selected and updated to the mysql table might hold a variety of values in a comma-delimited array. That works fine. When the Ad is edited on its own page, (outside of the Wordpress admin dashboard) the problem is that if a user would uncheck all checkboxes in a particular multiple checkbox then the unselected state does not overwrite the previous array of values. What returns after editing is the previous selected values. so one type of checkbox might have a hypothetical value like this  "name="cp_checkbox_help[]" and if three options are selected then on submit the value could be--- name="cp_checkbox_help[Sunday,Monday,Tuesday]"

I use implode and explode to store the array as comma separated and retrieve the array for editing or display. I guess I need to create a Null or empty value as a default that only changes when selections are made. But, since I use implode and explode to make the array "pretty" I don't know if simply specifying nothing will erase a whole array on update. Here is some of the code used to see how I get what I get-- This displays the checkboxes that I create and name and fill with different values--

case 'checkbox':

?>
<?php 
$options = explode(',', $result->field_values);
echo '<div id="checkboxes"><table width="100%" border="0" cellspacing="0" cellpadding="5">

[code]....

I have a feeling what I need is just a couple of lines to detect no posted values and then... but if one checkbox array has 6 values in it and another checkbox array has only 3 values, for example, do I need to count each specific checkbox for number of values and then overwrite or will one function completely delete the previous array and its commas?

View 9 Replies View Related

Present An Array Of Data, And The Corresponding Primary Key And Let The Code Work Out Whether To INSERT Or UPDATE It.

May 11, 2006

There's lots of DB abstraction layers out there, but a quick look around
them hasn't turned up anything which seems to met my requirements. Before I
go off and write one I thought I'd ask here if anyone knows of such a
beast...

I want some code where I present an array of data, and the corresponding
primary key and let the code work out whether to INSERT or UPDATE it, I
also want to be able to present the data from a QBF or QBE then be able to
step through the result set. However I don't want to have to configure the
DBMS structure - after all most of it is already in the DBMS (OK so not the
relationships in a MySQL db). It'd be really cool if I could throw SQL
directly at it *too*.

View 25 Replies View Related

Use Parse_ini_file Returned Associative Array To Return Values And Update The Ini File?

Apr 17, 2011

I have a config.ini file, I need to read values from it and to write to it and update it.this function "parse_ini_file" returns an associative array from the ini file, right now I'm looking into how to access the array to retrieve values.But how do I update those values? I guess it would be possible to just store them in the returned array, but how do you save it back to the ini file?

View 1 Replies View Related

Update A Table Based On Values From A Session Array In A Shopping Basket?

May 23, 2010

I am trying to update a table based on values from a session array in a shopping basket. When i add to cart i have the following method:

PHP Code:

public function AddToCart(){
!isset($_SESSION['ID']) ? $_SESSION['ID'] = array() : '';
!isset($_SESSION['theName']) ? $_SESSION['theName'] = array() : '';

[code]....

Now when someone confirms an order i need to update the stock list to mange the stock control. Therefore i need to update the stock value based on the quantities of the items in the basket. So i tried doing this:

PHP Code:

public function deductQuantitiesFromItems(){
$i=0;
session_start();

[code]....

Warning: Invalid argument supplied for foreach() in G:xampphtdocsManstoreModelsCart.class.php on line 121

View 24 Replies View Related

Little POST And MySQL Update ( Combining Search And Multiple Record Update )?

Jul 1, 2010

Well after scratching my head for too long, I give in, I've got to ask or I'll go crazy! I've been fiddling with PHP/MySQL again recently and although I successfully get a search of the db via a form field and have found a way* of adding a checkbox and update multiple records (a popular request I think!), my next hurdle is combining them.

I was hoping I could mash the script together (logically with my limited knowledge) to produce a 3 stage script. Page1 would send Page2 the search term (works so far) and then Page2 would send itself(and the db) those recorded selected for updating.

So far, when I try to I'm getting many errors, and I believe they occur because the script is trying to get information that's not there (from the search). Also it's because I've tried to modify existing code and I'm really guessing now :-(

Here's the code on the second page, the first page simply has a $_POST in it and then the second page collects that info:

[Code]...

It might be worth knowing that security isn't an issue as this script is run offline via WAMPServer (a brilliant freebee for testing!). Well, I really look forward to any comments,

View 7 Replies View Related

Use Hyperlink Update To Update Values Inside Mysql Database Via Textboxes?

May 3, 2011

how yo use hyperlink update to update values inside Mysql database via textboxes .

View 3 Replies View Related

Update JQuery To Allow Mutiple Button Clicks To Dynamically Call/update Data Using Ajax?

May 3, 2010

i'm able to capture the first button on the page, but there are a total of 10 buttons. When I click on any of those 10 buttons, only the first button's value is called and the other ones don't update. is there a way to capture all of the buttons so they each have their own independent value and update their values so jQuery's ajax function gets the new one? the buttons are being created out of a multidimensional array loop.

<?php
$characters = $char->getCharactersListFromAccountId($_SESSION['acctid']);
foreach ($characters as $key) {
if(is_array($key)){
echo "<input class="button" type="button" href="javascript:void(0)" value="Show" style="vertical-align: top" />";

[Code]....

View 1 Replies View Related

Update Query - Way To Update All Records That Meet Only A Part Of Field

Nov 8, 2005

I know that if you use the following code..

UPDATE
table
SET
field = ""
WHERE
field1 = ""

than it will change `field` in all records that meet the criteria of field1. What I need to know is there a way to update all records that meet only a part of field1

ie...

UPDATE
table
SET
field = "yummy"
WHERE
field1 = "apples|oranges"

if field one contains apples|oranges|grapes

it would still pick up that record.

View 3 Replies View Related

Update Mysql_fetch_array / Update Column With New Data.$result2 Line?

Oct 4, 2009

As you will see I am fetching the column, and trying to update column with new data.$result2 line is my problem, I don't think I can add $row[0] in there. How do I do it?

$result = mysql_query("SELECT link FROM items LIMIT 3");
while($row = mysql_fetch_array($result))
{
$url=($row[0]);
$rez2 = get_final_url($url);
$result2 = mysql_query("UPDATE items SET link = $rez2 WHERE id = $row[0] LIMIT 1")
or die(mysql_error());

View 3 Replies View Related

Apache Does Not Update Media Files When Update Tham In FileSystem?

May 26, 2010

Why Apache does not update media files when I update them in my file system? (I use xampp on Windows to manage Apache) So when I update my php files I see changes immediately byt when I update media files like .swf's it does note update them when I call them. Why, and how to solve such problem?

View 2 Replies View Related

UPDATE Clause In MYSQL Update Multiple Records In One Query?

Nov 12, 2008

well i have this messages table with sample values like these:

msg_id recipient_id read locked new
0 1 N Y Y
2 1 Y N N

ok, so lets just say this is a messaging table, and i want to reset all messages addressed to recipient with id=1 i was wondering why UPDATE `messages` SET `new`='Y',`read`='N',`locked`='N' where `recipient_id`=1;

doesn't work, MYSQL always returns 0 affected rows.. to robert gamble: yes, im sure the values were changed, since my purpose for this update query is to reset the data i was using for the testing phases :D

View 3 Replies View Related

ADVERTISEMENT