Rabu, 30 Oktober 2013

PHP Indonesia - Facebook: $sql2=odbc_exec($conn,"SELECT Userinfo.Name,Checki...

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/ 
Want free Kindle ebooks?

Sign up to receive the best freebie Kindle ebook deals in your email every day.
From our sponsors
$sql2=odbc_exec($conn,"SELECT Userinfo.Name,Checki...
Oct 30th 2013, 09:21, by Nurul Laily

Nurul Laily 9:21am Oct 30
$sql2=odbc_exec($conn,"SELECT Userinfo.Name,Checkinout.CheckType,Checkinout.Userid,Userinfo.Userid FROM Checkinout,Userinfo WHERE Checkinout.Userid=Userinfo.Userid and CheckType='I'");

memang nya beda ya query untuk ms access dengan query mysql?
maksud error disini apa?

Asep Aziz 9:24am Oct 30
string koneksinya?

Nurul Laily 9:27am Oct 30
diambil dari sini

<?php
$dsn='ecdb3';
$user='';
$pass='';
$conn=odbc_connect($dsn,$user,$pass);
?>

saat query saya tulis "select*from Userinfo" dia masih bisa run.. tapi saat saya tambah Checkinout.Userid=Userinfo.Userid itu jadi error :(

Asep Aziz 9:29am Oct 30
itu ngambil data dari 2 tabel?

Asep Aziz 9:30am Oct 30
harusnya pake inner join atau left join

Nurul Laily 9:30am Oct 30
iya.. mmm saya coba dulu ya

Vicky Suprayogi Ibrahim Karno 9:41am Oct 30
SELECT Userinfo.Name,Checkinout.CheckType,Checkinout.Userid,Userinfo.Userid FROM Checkinout INNER JOIN Userinfo ON Checkinout.Userid=Userinfo.Userid WHERE Checkinout.CheckType='I';

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