sandis_m Posted June 19, 2010 Report Share Posted June 19, 2010 Kāds varētu izskatīties SQL kverijs, kas izvelk visus lietotājs + vēl profila dāvanas Šobrīd gan izdevās tikai izvilkt lietotājus ar dāvanām. SELECT gifts.*, users.* FROM all_user_gifts g, all_usrs users WHERE gifts.sendto = user.uid Quote Link to comment Share on other sites More sharing options...
Klez Posted June 19, 2010 Report Share Posted June 19, 2010 iemācies tak jautājumu uzdot ibio (tā itkā mēs zinātu kādas tev tabulas ) ... cik reizes teikt ka te nevienam nav kristālu bumbas ... paskatīes googlē: mysql left join Quote Link to comment Share on other sites More sharing options...
php newbie Posted June 19, 2010 Report Share Posted June 19, 2010 es sapratu ko viņš grib. Laikam ņubi runā vienā valodā :) tas ko tev vajag ir left outer join Quote Link to comment 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.