briedis Posted June 9, 2010 Report Share Posted June 9, 2010 Nošaut nedrīkst apžēlot ;) Quote Link to comment Share on other sites More sharing options...
gta1151 Posted June 18, 2010 Author Report Share Posted June 18, 2010 (edited) Mēģināšu paskaidrot,veidoju komentāra script bet nezinu ka izvelk lietotāju kas ir rakstījis komentāru. Edited June 18, 2010 by gta1151 Quote Link to comment Share on other sites More sharing options...
briedis Posted June 18, 2010 Report Share Posted June 18, 2010 (edited) Ja tev komentāri glabājas vienā tabulā, lietotāji otrā: SELECT c.comment_text as komentars, u.user_nickname as lietotajs FROM comments_table c, users_table u WHERE c.user_id = u.user_id Edited June 18, 2010 by briedis Quote Link to comment Share on other sites More sharing options...
gta1151 Posted June 18, 2010 Author Report Share Posted June 18, 2010 Biju atradis vienu komentāru kopā profila,bet rāda kļūdu Scripta links Error Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'adasdsasa')' at line 1 Quote Link to comment Share on other sites More sharing options...
briedis Posted June 18, 2010 Report Share Posted June 18, 2010 Kļuda kvērijā... meklē pats.. Quote Link to comment Share on other sites More sharing options...
gta1151 Posted June 18, 2010 Author Report Share Posted June 18, 2010 (edited) Izlaboju,paskaties bildē Edited June 18, 2010 by gta1151 Quote Link to comment Share on other sites More sharing options...
Pentiums Posted June 18, 2010 Report Share Posted June 18, 2010 sadzoino lietotaju un komentaru tabulas un bus tev niks nevis nullite Quote Link to comment Share on other sites More sharing options...
mefisto Posted June 18, 2010 Report Share Posted June 18, 2010 Google : mysql left join Quote Link to comment Share on other sites More sharing options...
gta1151 Posted June 18, 2010 Author Report Share Posted June 18, 2010 Kāds nevar uzrakstīt komentāru script. Quote Link to comment Share on other sites More sharing options...
Леший Posted June 18, 2010 Report Share Posted June 18, 2010 Žēl, ka nevar... Quote Link to comment Share on other sites More sharing options...
mounkuls Posted June 18, 2010 Report Share Posted June 18, 2010 Kāds nevar uzrakstīt komentāru script. Lielākā daļa var. Ko mēs no tā iegūstam? 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.