Jump to content

Kevz

New Members
  • Content Count

    2
  • Joined

  • Last visited

Everything posted by Kevz

  1. Kevz

    MySQL Join breaking

    yeah sorry that was just typo on here. i fixed it with this query instead SELECT d.id,d.dish,d.items,d.locationid,d.inlist,l.location FROM dishes AS d LEFT JOIN location AS l ON d.locationid = l.id ORDER BY dish ASC thank you, why shouldn't i store as comma seperated?
  2. Creating a shopping list app, i have a drop down to display the location of the item or meal dishes table id | dish | items | locationid :--------|:--------:|---------:|---------: 1| fajitas | chicken,wraps | 1 2| curry| chicken,tomatos | 1 2| | mayonaise | 2 location table id | location :--------|:--------: 1| meal 2| fridge displaying items with this query SELECT * FROM dishes LEFT JOIN location ON dishes.locationid = location.id ORDER BY dish ASC" however now, it's taking the locationid, and using that as the dish id, so things like edit are broken as it's grabbing the wrong ID, am i using the wrong join clause?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.