Sabtu, 24 Agustus 2013

PHP Indonesia - Facebook: mau tanya gan SELECT tbl_pemohon . * , tbl_sampel...

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/ 
Exotic travel ideas.

Searching for your next vacation destination? Subscribe to Off The Beaten Path, a newsletter featuring captivating locales to help you to plan your next trip.
From our sponsors
mau tanya gan SELECT tbl_pemohon . * , tbl_sampel...
Aug 24th 2013, 08:23, by Suseno Debian Lenny

Suseno Debian Lenny 8:23am Aug 24
mau tanya gan

SELECT tbl_pemohon . * , tbl_sampel.*, tbl_kategori_sampel.*
FROM tbl_pemohon
INNER JOIN tbl_sampel ON tbl_pemohon.sampel = tbl_sampel.id
INNER JOIN tbl_kategori_sampel ON tbl_sampel.id_ks = tbl_kategori_sampel.id

klo dirunning di SQL phpmyadmin bisa

SELECT tbl_pemohon . * , tbl_sampel.*, tbl_kategori_sampel.*
FROM tbl_pemohon
INNER JOIN tbl_sampel ON tbl_pemohon.sampel = tbl_sampel.id
INNER JOIN tbl_kategori_sampel ON tbl_sampel.id_ks = tbl_kategori_sampel.id
order by $sort $order limit $offset,$rows

pas dieksekusi di aplikasi kok malah keluar

Column 'id' in order clause is ambiguous

cc para om : Nurcahyo Al Hidayah, Eksa Aja, Komar Satriani, DLL semua penghuni group

kenapa yah

Suseno Debian Lenny 8:25am Aug 24
sundul om tfl

Hendra Agung Wijaya 8:33am Aug 24
itu udah jelas error-nya : kolom id pada bagian order by membingungkan. :)

Suseno Debian Lenny 8:36am Aug 24
iya gan ternyata order by membingungkan order by $sort $order pas dihapus bisa

Suseno Debian Lenny 8:39am Aug 24
SOLVED gan
tenyata disini

$sort = isset($_POST['sort']) ? strval($_POST['sort']) : 'tbl_pemohon.id';
ditambah nama tabel tbl_pemohon

$sort = isset($_POST['sort']) ? strval($_POST['sort']) : 'tbl_pemohon.id';

thank for respon

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar