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? 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 Link to comment https://forums.phpfreaks.com/topic/91695-mysqlphp-coding-help/#findComment-469618 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.