fenway

I'm sorry -- sys_city ID field *is* auto-increment? If so, you're done -- just leave out the ID fields from both sides, and you'll get what you want.

So you're asking how to create users?

What do you want us to do?

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=314466.0

Sorry, I don't follow.

Huh?

I don't follow what's desired here.

If you have some sample data, I'd love to play around with it.

This is a very serious concern -- and in general, a true "rollback" is all but impossible.

I don't see why you simply don't like the colours to the models.

Please, let's not resort to posting large code snippets of JQuery with no PHP/MySQL in sight. if the DB problem has been resolved, I'll move this thread to a move appropriate board for resultion.

Clearly, I'll have to re-read this when I'm not the middle of a work-day -- you're telling me this works even with arbitrary IDs?

Then, solved?

Not even necessary -- you have the ID already!

I don't see any reference to item comments in your query.

You'll need to check the value for Col2 across all rows before you write the CSV.

But wouldn't I have to make a seperate row for each and every relation between product and accessory? Indeed.

Yes there is -- as you check each row in order.

I'm not sure I follow -- just limit your export.

I'm not sure I follow -- if you're issuing the update statement, then you know which fields were changed...?

What's wrong with BETWEEN?

A few user variables should do the trick -- update one whenever Col1 changes, increment the other when it doesn't.

Did the JOIN not work?

That requires joining the table to itself as many times as you has Qs.

It's not that it lacks anything, per se -- just that the default mix on HTML and scripting blurs the line for new programmers, and then they never completely recover.