PHP Indonesia - Facebook | PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
 | Manage your social media
Best social media tool for image publishing to Facebook and Twitter. Look amazing and delight your followers. Get 40% off when you sign up today.  | From our sponsors | | |
[tanya] mau nanya gan untuk nampilin database biar... Sep 14th 2013, 10:39, by Adieta Nugraha | [tanya] mau nanya gan untuk nampilin database biar hanya 5 data inputaN terbaru yg tampil pad web gmn yahh..sintax sql nya??terimakasih |
| | struktur tabel please |
| | select nya pake ASC aja trus di kasih LIMIT 5 |
| | gini gan ane mau bikin tampilan buku tamu tpi biar datanya 5 komentar terbaru yg muncul dgn sql gni
$query=mysql_query("SELECT * FROM bukutamu "); Database ="bukutamu" field="Nama",Komentar ane blm paham betull |
| | Buatkan idbukutamu auto incremen $query=mysql_query("Select * from bukutamu order by idbukutamu desc limit 5 "); |
| | udah dibikin gan tp blm bisa jg.. $query=mysql_query("SELECT * FROM bukutamu where publish='Y'"); model sintaxy kyk gtu dimana ada table publish untuk menyeleksi biar bisa tampil..nahh untuk nampilin 5 komentar terbaru,sintax sqlY gmn |
| | tambahin aja tgl_posting, nanti querynya gini
SELECT * FROM bukutamu WHERE publish='Y' ORDER BY tgl_posting DESC LIMIT 5 | | |
|
Tidak ada komentar:
Posting Komentar