update and arrays

code:
---------------------------

record_set('artGalNames',"SELECT * FROM art_gallery WHERE artgal_Name = $_POST[name]");
      
      //update the order
      if ($_POST) {
            mysql_query("UPDATE art_gallery SET
                  artgal_Name= '".$_POST[name]."',
                  WHERE artgal_Name = ".$_POST[name]."
            ");

---------------------------

The code below is being used to update the name of an artist in a database called art_gallery
A form posts the artist's name (name) which is used to select an array from art_gallery where all the names = name (the artist's name is represented multiple times)

I need to be able to introduce a loop  which will update ALL the records where the artgal_Name = name
doctorbillTechAsked:
Who is Participating?
 
Mark BradyConnect With a Mentor Principal Data EngineerCommented:
<?php

$sql = "UPDATE `tablename` SET `column` = 'test1' WHERE `column` = 'test'";

$result = mysql_query($sql);

if (!$result) {
    die(mysql_error());
}

?>

Open in new window

0
 
Mark BradyPrincipal Data EngineerCommented:
Two things

1: What is record_set() ? Not sure what that is trying to do.
2: Your query logic doesn't make sense.

You are trying to update a field with the value that is already in that field.

If there is a record in the table and the artgal_Name for that record is 'John Smith'

Your query is going to try to update that record to 'John Smith'

Perhaps if you can post a database schema so I can see how it is built then supply a bit more information as to what the form actually does.

Then I can certainly help you with the code.

Cheers
0
 
doctorbillTechAuthor Commented:
Can you give me an example of updating multiple records in a database :
for example, the database has a variable number of entries with the name "test

I want to be able to update all entries with the name "test" to "test1"

I am ok with database connections and showing records - it is just the looping part I am having a problem with
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Mark BradyConnect With a Mentor Principal Data EngineerCommented:
UPDATE `tablename` SET `column` = 'test1' WHERE `column` = 'test';


That query is not a loop but it will update ALL records where the value is 'test'

`tablename` and `column` need to be renamed with your table name and the column name you are using.
0
 
doctorbillTechAuthor Commented:
How is this put in between php tags on a php page?

<?php


?>
0
 
doctorbillTechAuthor Commented:
solved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.