1 Replies - 2304 Views - Last Post: 25 July 2008 - 01:00 PM

#1 HowdeeDoodee  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 78
  • Joined: 17-June 08

PHP/MySql: Copy Values From One Table To Another Using Common Field

Posted 25 July 2008 - 11:25 AM

I have googled and regoogled and could no find a specific answer or code to work from.

I have two tables in the same database.
The first table is named TextInserter.
The second table is named Clarke

There are two common fields between the two tables. The names of the common fields are VerseRef and VerseText.

In the second table named Clarke, the VerseText field is empty or has no values.
In the table named TextInserter, the VerseText field has data.
The common field, VerseRef, has values in both tables.

Using phpMyAdmin, I want to copy the field values from Inserter.VerseText over to Clarke.VerseText where there is a common value in the VerseRef field.

Thank you for your time and replies.

Is This A Good Question/Topic? 0
  • +

Replies To: PHP/MySql: Copy Values From One Table To Another Using Common Field

#2 HowdeeDoodee  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 78
  • Joined: 17-June 08

Re: PHP/MySql: Copy Values From One Table To Another Using Common Field

Posted 25 July 2008 - 01:00 PM

Mods, if you would be so inclined, could you delete this thread. Displaying the data I need desplayed likely requires using two tables to display the data rather than just one table.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1