andrew_biggart Posted May 27, 2008 Share Posted May 27, 2008 Hey there il try and keep this short but basically i am designing an online clothing auction site and i would like to get the all item id's from my bids table that = my user id, and once i get all of the results i then want to get all the item info which is in a different table usuing the returned item id's from the bids table. Do i need to use 2 sql statements or what do i need to do ??? hope this makes some sense and thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/107448-selecting-one-table-and-using-info-from-that-to-get-other-info-from-another-tabl/ Share on other sites More sharing options...
Barand Posted May 27, 2008 Share Posted May 27, 2008 A single query joining the two tables would be better Quote Link to comment https://forums.phpfreaks.com/topic/107448-selecting-one-table-and-using-info-from-that-to-get-other-info-from-another-tabl/#findComment-551035 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.