Lets say I‘m having a list of adverts on one page. This list with my adverts comes from a Database:
table adverts:
- id
- id_customer
table customer:
- id
- name
now comes the point where I use two modal windows (modalupdateAdvert, modalupdateCustomer) on same page with each formupdate statements. Now it looks like its mixing up the „id“ from customer with the one from adverts and I‘m getting strange update results.
Now I have to say, that I‘m just querying * all (asterisk/joker query) from adverts and customers, so I have more flexibility later, instead of defining and giving each column of my query an alias.
That mixing with id‘s remembers me from my old times, when using dreamweaver back in 2002…
@ben How do you handle that uniqueness? I‘m using these modals and update statements on same page, cause its slim and later for translating it would be easier to manage just one file, instead of having each update forms on separate pages.
by the way I‘m using also a temporary variable to pass the id‘s to the modal forms.