uwannadonkey Posted February 18, 2008 Share Posted February 18, 2008 i have a table, lets name the table, "food" in table food, theres different kinds of food, and there are chances of one person having multiple amounts of food. how do i select the first instance where id = $user->ID and where item name is apple? Quote Link to comment https://forums.phpfreaks.com/topic/91695-mysqlphp-coding-help/ Share on other sites More sharing options...
pocobueno1388 Posted February 18, 2008 Share Posted February 18, 2008 Try: SELECT * FROM food WHERE id=$user->ID AND item_name='apple' LIMIT 1 Quote Link to comment https://forums.phpfreaks.com/topic/91695-mysqlphp-coding-help/#findComment-469618 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.