I'm kinda new to php and mysql. I'm making a basic shopping cart using 2 database tables. I want my cart to display items from the 2 tables into 1 html table.
I ran into a problem giving the 2 database tables the same id name, so now I want to change them. But I want to keep them at auto_increment.
Is it possible to give the id a name like TKT0000 that will auto increment as TKT0001, TKT0002 and so on? This will at least give the items from the different tables a different id name so the cart will work correctly.
Thanks in advance!