daviskrex Posted June 9, 2010 Report Share Posted June 9, 2010 (edited) Ilgi domāju, bet nevarēju izdomāt kā lai uztaisa sql kveiriju, kurš darbojas aptuveni šādi SELECT * FROM forum_posts WHERE forum_id= ar foruma id, kur admin=0 Varbūt kāds var padīdzēt sastādīt kveiriju? :) Paldies jau iepriekš. Edited June 9, 2010 by daviskrex Quote Link to comment Share on other sites More sharing options...
mefisto Posted June 9, 2010 Report Share Posted June 9, 2010 Palasi par JOIN'iem. Quote Link to comment Share on other sites More sharing options...
daviskrex Posted June 9, 2010 Author Report Share Posted June 9, 2010 Paldies. izdevās :) Ja kādam vajag: SELECT forum_posts.*, forums.* FROM forum_posts LEFT JOIN forums ON forum_posts.forum_id=forums.id WHERE forums.admin=0 Order by forum_posts.id DESC Limit 5 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.