Need help with data in columns!

Ok, I look "briefly" in this forum for some hints, no luck.

Here is what I have.

I'm pulling data from a foreign database and populating my database. (Real Estate)

The data comes in 2 feeds. "listings" and "listing_images"

I have created 2 tables in my database, "listings" and "listing_images". (The are multiple images for each listing.)

To keep this simple, I'm only going to name a few columns!

listings= listing_id, internal_listing_id

listings_images= internal_listing_id, index (which will be 1, 2, etc, etc)

Usually, to display all the images, all I would need to do is match up the images with the "listing_id".......

Here is the problem...

The image feed only consists of the internal_id and index.

The actual images are labeled with the "listing_id" !!!

E.G. from a listing
(Table>listings)

listing_id = 08-2334
internal_listing_id = 20045677896600

(Table>listings_images)
internal_listing_id = 20045677896600
index = 1 (2, _3, etc.)

Actual Image name = 08-2334.jpg

How do I go about renaming listings_images.internal_listing_id to match that of listings.listing_id ???

Sorry if it seems confusing, and I have no clue why the MLS provider has marked it this way!

Any help would be highly appreciative!:eek:

If I understood right, this should do the trick:

UPDATE listings l,listings_images li  

SET li.internal_listing_id = l.listing_id 
WHERE l.internal_listing_id = li.internal_listing_id

That makes a lot of sense! I'm gonna try later this evening!

I appreciated it.... after I get it ironed out, I'll send a six pack your way!

cahva!

It worked like a charm!

PM me your addy. I'll send you a 6 pack!
🆒

You're welcome and thanks for the offer. I'm a big fan of beer but honestly you dont have to send me a sixpack 😉

Again, thank you. If there is ever anything I can help out with, just shoot me a message.

I do graphics, FLASH, AS, a little PHP, yada, yada, yada.