PHP - Update Table With Array

I've used a lot of solutions from this site, however, this is my first post, so go easy on me  :-)

I've created a product form the successfully INSERTS data to a mysql table. 
I can successfully query the data so that product information can be updated.

When I click submit to UPDATE the rows, everything updates except for 2 fields that are arrays.

Here is my product form that populates data to be edited.
Code: [Select]
<?php

session_start();

require("config.php");
require("db.php");
require("functions.php");

if(isset($_SESSION['SESS_ADMINLOGGEDIN']) == FALSE)
{
header("Location: " . $config_basedir);
}

if(isset($_GET['func']) == TRUE)
{

if($_GET['func'] != "conf")
{
header("Location: " . $config_basedir);
}

$validid = pf_validate_number($_GET['id'], "redirect", $config_basedir);

header("Location: " . $config_basedir . "adminedit.php");
}

else
{
require("header.php");



$sql = "SELECT * FROM products WHERE id = " . $_GET['id'] . ";";
$query = mysql_query($sql); 

while ($prodrow = mysql_fetch_array($query)){

$id = $prodrow['id'];
$active=$prodrow['active'];
$cat_id=$prodrow['cat_id'];
$name=$prodrow['name'];
$description=$prodrow['description'];
$details=$prodrow['details'];
$price=$prodrow['price'];
$price2=$prodrow['price2'];
$price3=$prodrow['price3'];
$price4=$prodrow['price4'];
$price5=$prodrow['price5'];
$price6=$prodrow['price6'];
$minimum=$prodrow['minimum'];
$price7=$prodrow['price7'];
$price8=$prodrow['price8'];
$price9=$prodrow['price9'];
$image=$prodrow['image'];
}

?>

<form action="adminprodupdate.php" method="post">

<table width="500" border="1" cellpadding="10">

<tr>
    <td>ID:</td>
    <td><input type="hidden" value="<? echo $id; ?>" name="id" /></td>
  </tr>
 <tr>
    <td>Active:</td>
    <td><input name="active" type="radio" value="0" <?php echo ($active=='0')? 'checked':'';?> />Yes<br />
       <input name="active" type="radio" value="1" <?php echo ($active=='1')? 'checked':'';?> />No</td>
  </tr>
  <tr>
    <td>Category:</td>
    <td><input name="cat_id" type="radio" value="1" <?php echo ($cat_id=='1')? 'checked':'';?> />Hats<br />
    <input name="cat_id" type="radio" value="2" <?php echo ($cat_id=='2')? 'checked':'';?> />Shirts<br />
    <input name="cat_id" type="radio" value="3" <?php echo ($cat_id=='3')? 'checked':'';?> />Promotional Items</td>
  </tr>
 
  <tr>
    <td>Product ID: </td>
    <td><input type="text" name="name" value="<? echo $name; ?>"></td>
  </tr>
 
  <tr>
    <td>Short Description: </td>
    <td><input type="text" name="description" value="<? echo $description; ?>"></td>
  </tr>
  <tr>
    <td>Details:</td>
    <td><textarea name="details" cols="50" rows="10" ><? echo $details; ?></textarea></td>
  </tr>
  <tr>
    <td>Price for S-XL:<br />
    <br /><strong><div id="redfont">**Shirts**<br />&<br />**Hats**</div></strong></td>
    <td>1-23: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price" value="<? echo $price; ?>"><br><br>
    24-47: &nbsp;&nbsp;<input type="text" name="price2" value="<? echo $price2; ?>"><br><br>
        48+: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price3" value="<? echo $price3; ?>"><br><br>
    </td>
  </tr>
  <tr>
    <td>Price for 2XL - 5XL:<br />
    <br /><strong><div id="redfont">**Shirts ONLY!**</div></strong></td>
    <td>1-23: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price4" value="<? echo $price4; ?>"><br><br>
    24-47: &nbsp;&nbsp;<input type="text" name="price5" value="<? echo $price5; ?>"><br><br>
        48+: &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="price6" value="<? echo $price6; ?>"><br><br>
    </td>
  </tr>
  <tr>
    <td>Minimum QTY: </td>
    <td><input type="text" name="minimum" value="<? echo $minimum; ?>"></td>
  </tr>
 
<tr>
<td>Sizes:</td>
<td><?
echo '';

$result = mysql_query("SELECT * FROM sizes");
while ($row = mysql_fetch_assoc($result)) {
$selected = '';
$result2 = mysql_query("SELECT * FROM productoptions WHERE productid = '" . $_GET['id'] . "' AND sizeid = '" . $row['id'] . "'");
if ($row2 = mysql_fetch_assoc($result2)) {
$selected = 'checked ';
}
echo '<input type="checkbox" name="size[]" value="' . $row['id'] . '" ' . $selected . '/> ' . $row['size'] . '<br />';
}

?>
</td>
</tr>
<tr>
<td>Colors:</td>
<td><?


$result = mysql_query("SELECT * FROM colors");
while ($row = mysql_fetch_assoc($result)) {
$selected = '';
$result2 = mysql_query("SELECT * FROM productoptions WHERE productid = '" . $_GET['id'] . "' AND colorid = '" . $row['id'] . "'");
if ($row2 = mysql_fetch_assoc($result2)) {
$selected = 'checked ';
}
echo '<input type="checkbox" name="color[]" value="' . $row['id'] . '" ' . $selected . '/> ' . $row['color'] . '<br />';
}

?>
     
</td>
</tr>
   <tr>
  <td>&nbsp;</td>
  <td><input type="Submit" value="Update this product"></td>
  </tr>
</form>
</table>

<?php

}

require("footer.php");
?>
Here is my script:
Code: [Select]
<?php


include("config.php");
include("db.php");

$id=$_POST['id'];
$active=$_POST['active'];
$cat_id=$_POST['cat_id'];
$name=$_POST['name'];
$description=$_POST['description'];
$details=$_POST['details'];
$price=$_POST['price'];
$price2=$_POST['price2'];
$price3=$_POST['price3'];
$price4=$_POST['price4'];
$price5=$_POST['price5'];
$price6=$_POST['price6'];
$minimum=$_POST['minimum'];
$arrsizes = $_POST['size'];
$arrcolors = $_POST['color'];
$image=$_POST['image'];


$sql="UPDATE products SET active = '$active', cat_id = '$cat_id', name = '$name', description = '$description', details = '$details', price = '$price', price2 = '$price2', price3 = '$price3', price4 = '$price4', price5 = '$price5', price6 = '$price6', minimum = '$minimum', image = '$image' WHERE id = '$id'";



$result = mysql_query("SELECT id FROM products ORDER BY id DESC LIMIT 0,1");

if ($row = mysql_fetch_assoc($result)) {
$productid = $row['id'];
}

foreach ($arrsizes as $sizevalue) {
foreach ($arrcolors as $colorvalue) {
$sql2="UPDATE productoptions SET sizeid = '$sizevalue', colorid = '$colorvalue' WHERE productid='$id' ";

}
}

mysql_query($sql) or die ("Error: ".mysql_error());
mysql_query($sql2) or die ("Error: ".mysql_error());


echo $sql;
echo $sql2;



header("Location: " . $config_basedir . "adminhome.php");



?>

And here is what is echo'd after submit:
Code: [Select]
UPDATE products SET active = '0', cat_id = '2', name = 'Test Edit Prod', description = 'just a simple test', details = 'just a simple testjust a simple testjust a simple testjust a simple testjust a simple testjust a simple test', price = '1', price2 = '2', price3 = '3', price4 = '4', price5 = '5', price6 = '6', minimum = '127', image = '' WHERE id = '41'UPDATE productoptions SET sizeid = '6', colorid = '5' WHERE productid='41'
This part of the code:   UPDATE productoptions SET sizeid = '6', colorid = '5' WHERE productid='41'   , is supposed to be updating sizes and colors, however, it is only updating the last size/color selected in the check box.

Thanks in advance for any support!

Hello

I have three tables

User

diysmps

usergroup


usergroupid is common in the three tables.

diysmps is joined on usergroup, so running this sql



SELECT
diysmps.name,
diysmps.email,
diysmps.sumbit,
diysmps.message,
diysmps.ID,
usergroup.title
FROM diysmps
INNER JOIN usergroup ON diysmps.usergroupid = usergroup.usergroupid
ORDER BY diysmps.ID DESC

see results i get in picture attached. the result (PENDIN REGISTRATION) is what i need to be updated WHEN the user register to the forums.

when the user register to the forums, an account with his EMAIL will be created into the (USER) table.

So, I need to look out for the email FROM (diysmps TABLE) into the user table _search user table for email from diysmps table_ and if found to update the USERGROUPID in (diysmps TABLE) withe the USERGROUPID from (USER) table (related to the email searched)

so, when user registers, status from PENDING REGISTRATION to REGISTERED will be shown

I know it looks complex for me, but thats how i can describe

Thanks all

How can  I use php to update a dynamic amount of input fields and tell mysql which ones to update respectively?  Essentially I have a list of occupations and if someone wants to update one of them I don't know how to tell php which one they've changed in a dynamic way.

Code: [Select]
<?php

if(!empty($occupations))
{

?>
<h3 id="job_function">Job Functions</h3>
<?php

$i = 0;

foreach($occupations as $occupation)
{

?>
<div class="formElement">
<div class="formFieldLabel ">
<label for="occupation_<?php echo $i; ?>"><?php echo $occupation['companyname']; ?></label>
</div>
<div class="formField">
<input id="occupation_<?php echo $i; ?>" type="text" name="occupation_<?php echo $i; ?>" value="<?php echo $occupation['function']; ?>" />
</div>
</div>
<?php

$i++;

}
}

?>

Hi all, 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);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>


<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center">Picture Name</td>
<td align="center">Upload Date</td>
<td align="center"><strong>No Downloads</strong></td>
<td align="center"> Approved?    </td>
<td align="center">  Hunnies Gallery   </td>
<td align="center">  Hunks Gallery   </td>
<td align="center">  Default Pic   </td>
<td align="center">   Theme Pic  </td>
<td align="center">   Homepage Pic  </td>
</tr>
<?php
while($rows=mysql_fetch_array($allphotos)){
?>
<tr>
<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>
<td align="center"><? $user_picture[]=$rows['user_picture']; ?><?php echo $rows['user_picture']; ?></td>
<td align="center"><? $user_picture_date[]=$rows['user_picture_date']; ?><?php echo $rows['user_picture_date']; ?></td>
<td align="center"><? $picture_downloads[]=$rows['picture_downloads']; ?><?php echo $rows['picture_downloads']; ?></td>
<td align="center"><? $user_pic_approval[]=$rows['user_pic_approval']; ?><?php echo $rows['user_pic_approval']; ?>    </td>
<td align="center"><? $hotties_gallery[]=$rows['hotties_gallery']; ?><?php echo $rows['hotties_gallery']; ?>   </td>
<td align="center"><? $hunks_gallery[]=$rows['hunks_gallery']; ?><?php echo $rows['hunks_gallery']; ?>   </td>
<td align="center"><? $default_pic[]=$rows['default_pic']; ?><?php echo $rows['default_pic']; ?>   </td>
<td align="center"><? $theme_gallery[]=$rows['theme_gallery']; ?><?php echo $rows['theme_gallery']; ?>   </td>
<td align="center"><? $homepage=$rows['homepage_pic']; ?><?php echo $rows['homepage_pic']; ?>   </td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $model_pictures SET user_pic_approval='$user_pic_approval[$i]', hotties_gallery='$hotties_gallery[$i]', hunks_gallery='$hunks_gallery[$i]', default_pic='$default_pic[$i]', theme_gallery='$theme_gallery[$i]', homepage_pic='$homepage_pic[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

Hi all,

I'm trying to figure out how to update values I have in an array.  I'm a bit stuck and hope someone can advise.

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`]

hope someone can point me in the right direction please...

Ted

Hi,

Ok, so I'm making a registration form system, where I can create new registration forms for the users to pick a date etc.

In my form I can add and remove text fields via Javascript - to add additional dates etc. so I don't know if I'll be submitting 3 fields or 15.

The could look like this:
<input type="hidden" name="session_id[]" value="<?php echo $session_id; ?>">
<input type="text" name="picked_date[]">
<input type="text" name="picked_room[]">

They are put in a big array:
De bliver smidt i et stort array:
$n=0;
    foreach ($session_id as $_session_id) {
        $bigar[$n][1] = $_session_id;
        $n++;
        }
        $n=0;
    foreach ($picked_date as $_picked_date) {
        $bigar[$n][2] = $_picked_date;
        $n++;
        }
        $n=0;
    foreach ($picked_room as $_picked_room) {
        $bigar[$n][3] = $_picked_room;
        $n++;
        }
        $n=0;

which is then updated in the database using:
foreach ($bigar as $part)
{
mysql_query("UPDATE...
}

Right - so far so good. The updating works fine with existing fields, but if I remove some of the fields (via JS) it obviously only updates the remaining in the array. The left out will be ignored. On the same note I would like to add fields as well, so - the bottom line - I want to:

- UPDATE rows, where the ID is in the array
- DELETE existing rows, WHERE the ID is NOT in the array
- CREATE new rows for the new fields in the array (not having an ID)

How can this be achieved? Hope someone can help...

I have made a thread earlier but i did not get any help.

changeapp.php
Code: [Select]
<form method="post" name="memberadd" action="change_app_complete.php">

<label>Name:</label>
<select name="member">
<?php
$con = mysql_connect("host","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);
$sqlquery="SELECT * FROM `application` Order By Name";
$result=mysql_query($sqlquery,$con);
while($row=mysql_fetch_array($result))
{
echo "<option value='".$row['ID']."'>".$row['Name']." (".$row['Status'].")</option>";
}
?>
</select>
<br>

<label>Status:</label>
<select name="Status">
<option value="PENDING">PENDING</option>
<option value="ACCEPTED">ACCEPTED</option>
<option value="DENIED">DENIED</option>
<br>
<input type="submit" value="submit" />
</form>

change_app_complete.php
Code: [Select]
<?php
$status=$_POST['Status'];
$member=$_POST['Name'];

$con = mysql_connect("host","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);

$sql="UPDATE application SET Status = '$status' WHERE Name= '$member'";
if(mysql_query($sql,$con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
mysql_close($con);

?>
This does not return any errors and does not change the Status...

---- I can not do this : $sql = mysql_query("UPDATE myMembers SET email_activated='1' WHERE id='$id' AND password='$hashpass'");
---- i get this: $msgToUser = "<br /><br /><h3><strong><font color=red>Your account could not be activated!</font></strong><h3><br />
        <br />
        Please email site administrator and request manual activation.
        ";

thanks guys

ok so here is whats going on i have this small little php to update one thing in a table but it's not updating the mysql_error is
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'check=1 WHERE id='21'' at line 1
what is the prob because i spent a hour on this and cant git it?
 here is the php

Code: [Select]
<?php
include '../config.php';
$id = $_GET['del'];
mysql_query("UPDATE call_list SET check=1 WHERE id='$id'")or die(mysql_error()); 
header("Location: index.php");
?>

hey forum people
can you help me on one problem so i have script what should update mysql table by username
Code: [Select]
UPDATE data SET username='$name' WHERE value1='$value1' AND value2='$value2' AND value3='$value3' AND value4='$value4' AND value5='$value5'any ideas ?

I'm pretty inexperienced with coding and trying to get a row of a MySQL database to update when a form is submitted, but can't seem to get it to work. 

Here's what I have...

Code: [Select]
if($_POST['action'] == 'update'){
    //update
    $rename = $_POST['rename'];
    $uid = $_POST['rowid'];
    mysql_query("UPDATE `master` SET `name` = '$rename' WHERE `id` = '$uid'");

}

Then the form...
Code: [Select]
<?php

        $result = mysql_query("SELECT * FROM `master`");
        if(mysql_num_rows($result)){
        while ($row = mysql_fetch_array($result)){
        ?>
          <td><?php echo $row['name']; ?></a></td>
            <td><input type="text" size="5px" name="rename" value="" /></td>
         
           <td><input type="hidden" name="rename" value="<?php echo $row['name']; ?>" /><input type="hidden" name="rowid" value="<?php echo $row['id']; ?>" /><input type="hidden" name="action" value="update" /><input type="submit" value="Update" /></td>
            </tr>
            <?php
}
}
        ?>
Can anyone give me some hints as to why this won't work? Thaks!

Hi there. I have a page that lists the records of a table. On this page I want to be able to edit/update two attributes of these records by a checkbox - e.g., being able to update multiple records at once. I thought the smartest way to achieve this would be by using arrays. I've implemented one checkbox array and have two fields. Currently when I change both fields and hit submit, the height value changes and the name value is changed to the last record displayed in the table.

E.g.

Height - 170 -> 160 -> UPDATED TO 160
Name - Test1 -> Test2 -> UPDATED TO VICTORY (last record listed in table; displayed alphabetically)

My code is as follows:

<?php
include("connection.php");
$conn = oci_connect($UName,$PWord,$DB) or die("Database Error - Contact Admin - sjrei5@student.monash.edu");
if (empty($_POST["check"]))
{
    $query = "SELECT * FROM HORSE ORDER BY HORSE_NAME";
    $stmt = oci_parse($conn,$query);
    oci_execute($stmt);
$Horses = oci_fetch_array ($stmt);
?>
    <form method="post" action="horse_multi.php">
      <table border="1" id="customers">
      <tr>
        <th>ID</th>
        <th>EDIT</th>
        <th>NAME</th>
        <th>HEIGHT</th>
      </tr>
<?php
while ($Horses = oci_fetch_array ($stmt))
{
?>
        <tr>
          <td><?php echo $Horses["HORSE_ID"]; ?></td>
          <td align="center"><input type="checkbox" name="check[]" value="<?php echo $Horses["HORSE_ID"]; ?>"></td>
          <td align="center"><input type="text" size="5" name="<?php echo $Horses["HORSE_ID"]; ?>" value="<?php echo $Horses["HORSE_HEIGHT"]; ?>"></td>
          <td align="center"><input type="text" size="20" name="HORSE_NAME" value="<?php echo $Horses['HORSE_NAME']; ?>"></td>
        </tr>
<?php
}
?>
      </table><p />
        <h4><input type="submit" value="Update Selected Horses"></h4>
    </form>
<?php
oci_free_statement($stmt);
}
else
{

foreach($_POST["check"] as $horse_id)
{
$query = "UPDATE HORSE SET HORSE_NAME= '$_POST[HORSE_NAME]', HORSE_HEIGHT = ".$_POST[$horse_id]." WHERE HORSE_ID ='".$horse_id."'";
$stmt = oci_parse($conn,$query);
oci_execute($stmt);
}
}
?>
</body>
</html>


Any ideas? 

Code: [Select]
//Update the ranks
if (isset($_POST['update'])){
$ids = implode(",", array_map('intval', $_POST['m']));
$ranks = implode(",", array_map('intval', $_POST['ranks']));
if ($ids < 1)
message("Incorrect Data");
if ($ranks < 0)
message("Incorrect Data");
foreach ($_POST['ranks'] as $muffins){
$db->query('UPDATE friends set rank = '.$muffins.' WHERE friend_id = '.$_POST['m'].' AND user_id = '.$pun_user['id'].'') or error('Unable to remove users from online list', __FILE__, __LINE__, $db->error());
}
redirect("s.php?section=Friends","Thanks, Ranks Updated");
}
friend_id = becomes blank? the $muffins work and each rank is showed respectivaly, but how can I join in another array in the loop? I tried another foreach in the loop, but it just made me run double the queries.

Any idea? $muffins is working fine and $_POST['m'] is giving no results  i need to have 2 dynamic arrays in that forloop, the $ranks and the $ids

Hi,

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);

        $maxquery = "SELECT MAX(CPid) as max FROM ConfPaper WHERE CPRid = ".$_GET['CPRid'];
        $maxresult = mysql_query($maxquery);
        $max = mysql_fetch_array($maxresult);
        $CPid = $max['max'];

        if($result && mysql_num_rows($result) > 0)
        {
            $sqlValues = array();
            while(list($PId, $PName) = mysql_fetch_row($result))
            {
                if(in_array($PName, $authArray))
                {
                    $sqlValues[] = sprintf("(%d, 1, ".$CPid.", %d, now(), 0)", $PId
                                                               , $PCorder++ );
                    // Author already exists within the Pname table
                    // remove user from $authArray
                    $key = array_search($PName, $authArray);
                    unset($authArray[$key]);
                }
            }
        $sql  = "INSERT INTO PeopleCon(Person_id, PCHid, Pid, PCorder, PCdateadded, PCdeleted) VALUES \n";
        $sql .= implode(",\n", $sqlValues);
        $result = mysql_query($sql);
        }
        // If there are Authors left within the $authArray
        // Add them to the Pname table
        if(count($authArray) > 0)
        {
            People::insertPersons($authArray); // call insertPersons method for remaining authors
            $this->insertAuthor($authArray, $PCorder); // insert the remaining auhtors into PeopleCon
        }
    }


insertPersons method is as such:


    public function insertPersons($PName)
    {
        $query = "INSERT INTO People (Pname) VALUES ('" . implode("'), ('", $PName) . "')";
        $result = mysql_query($query);
    }


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.

Can anyone help me out as to how i should go about tackling this?

Thanks

Kind regards
Billy

Hi all,
I need to create a button my page that when clicked will update my mysql table.
I also need a command that will find 3 'x' values and update them accordingly,

It needs to update the theme column in my model pictures table, Would something similiar like this work?
Code: [Select]
UPDATE theme
SET name = '5'
WHERE name = '1 or 2 or 4';[code]

Does this make sense?