Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

php mysql update database what wrong with it

Posted on 2006-11-07
4
200 Views
Last Modified: 2011-10-03
update
sellhead.NewCCode  = customer.id
where  AOL.sellhead inner join AOL.customer on sellhead.CCode = customer.Code
0
Comment
Question by:teera
  • 3
4 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 350 total points
ID: 17895796
try

update sellhead, customer set sellhead.NewCCode  = customer.id where  sellhead.CCode = customer.Code
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 17895798
0
 

Author Comment

by:teera
ID: 17895819
update  sellhead
set sellhead.NewCCode  = customer.id
where  AOL.sellhead inner join AOL.customer on sellhead.CCode = customer.Code
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 17895837
no,

you need to mention both tables at the beginning - then join them later

just as I gave - and as the examples in what I posted above.

so

update sellhead, customer set sellhead.NewCCode = customer.id where sellhead.CCode = customer.Code
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

856 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