Solved

update and arrays

Posted on 2013-05-22
6
157 Views
Last Modified: 2013-05-23
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
0
Comment
Question by:doctorbill
  • 3
  • 3
6 Comments
 
LVL 20

Expert Comment

by:Mark Brady
ID: 39188518
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
 

Author Comment

by:doctorbill
ID: 39188545
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
 
LVL 20

Assisted Solution

by:Mark Brady
Mark Brady earned 500 total points
ID: 39188570
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:doctorbill
ID: 39188643
How is this put in between php tags on a php page?

<?php


?>
0
 
LVL 20

Accepted Solution

by:
Mark Brady earned 500 total points
ID: 39188658
<?php

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

$result = mysql_query($sql);

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

?>

Open in new window

0
 

Author Closing Comment

by:doctorbill
ID: 39191535
solved
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

707 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

15 Experts available now in Live!

Get 1:1 Help Now