Reseller Domain Murah dan termurah di Indonesia? ya di ResellerCamp.
         
 

Forum PHP Indonesia

Dapatkan pertolongan pertama pada kebingungan PHP dan sekitarnya

  
Advanced Search
    
 
Home Register FAQ Memberlist Usergroups  
  Log in to check your private messages Log in  
   
  Hosting Murah | Agen Iklan | Iklan Baris | Web Desain |  
 

Forum PHP Indonesia Forum Index MySQL Help gimana cara nampilin query yang kayak gini
Display posts from previous:   
      All times are GMT + 7 Hours  

gimana cara nampilin query yang kayak gini

Post new topic  Reply to topic

Tue Jul 27, 2010 10:13
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: gimana cara nampilin query yang kayak gini Reply with quote
table wilayah

id
area

table nama

name_id
username
kategori_id

gimana querynya biar bisa tampil begini

wilayah:

jakarta pusat (20 data)
tomang(3), setiabudi(10), tanahabang(7)

jakartatimur (12 data)
pasar rebo(1), rawamangun(7), pulogadung(2), condet(2)

jakbar(...
...................

jak sel(...
....................


querynya gimana yah???
 
View user's profile Send private message
      Back To Top  

Tue Jul 27, 2010 13:13
Author Message
wahyu
PHPuser
PHPuser


Joined: 09 Feb 2009
Posts: 37
Location: Yogyakarta
Post subject: Reply with quote
Kalo begini bagaimana :

Code:
<?php "SELECT  
(SELECT COUNT(*) FROM wilayah WHERE id='1') AS Jakarta  
(SELECT COUNT(*) FROM wilayah WHERE id='2') AS Rawamangun
* FROM wilayah " ?>


kode parameter 1 / 2 pada sub select diasumsikan kode wilayah
_________________
Hiasi hidup dengan ilmu yang bermanfaat
 
View user's profile Send private message Visit poster's website Yahoo Messenger
      Back To Top  

Tue Jul 27, 2010 13:58
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
wah error mas kek gini

#1064 - 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 '(SELECT COUNT(p.tempat)
 
View user's profile Send private message
      Back To Top  

Tue Jul 27, 2010 15:28
Author Message
andriant
Jagoan PHP
Jagoan PHP


Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
Post subject: Reply with quote
kurang komanya tuh
Code:
<?php "SELECT  
(SELECT COUNT(*) FROM wilayah WHERE id='1') AS Jakarta  ,
(SELECT COUNT(*) FROM wilayah WHERE id='2') AS Rawamangun
* FROM wilayah " ?>

_________________
Lagi Boker, Makan, Mau Tidur, Coding jangan lupa baca:
PHP Manual -> http://php.net/download-docs.php
MySQL Manual -> http://dev.mysql.com/doc/
 
View user's profile Send private message Visit poster's website Yahoo Messenger
      Back To Top  

Tue Jul 27, 2010 15:33
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
wah masih error mas

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 '* FROM wilayah' at line 4
 
View user's profile Send private message
      Back To Top  

Tue Jul 27, 2010 15:42
Author Message
andriant
Jagoan PHP
Jagoan PHP


Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
Post subject: Reply with quote
boleh minta struktur tabelnya dan data, dan output yang dimau bro? diatas pertanyaannya kurang jelas sih...
 
View user's profile Send private message Visit poster's website Yahoo Messenger
      Back To Top  

Tue Jul 27, 2010 15:45
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
nih table nama


CREATE TABLE IF NOT EXISTS `nama` (
`id` int(255) NOT NULL auto_increment,
`contact_person` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`phone` varchar(50) NOT NULL,
`address` varchar(255) NOT NULL,
`description` text NOT NULL,
`tempat` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`pubdate` datetime NOT NULL,
`for` text NOT NULL,
`hits` int(255) NOT NULL default '1',
`category_id` int(20) NOT NULL,
`area_id` int(255) NOT NULL,
`user_id` varchar(255) NOT NULL,
`status` varchar(25) NOT NULL default 'published',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=147 ;


nih table areanya atau wilayah


CREATE TABLE IF NOT EXISTS `area` (
`district_id` int(255) NOT NULL auto_increment,
`area_name` varchar(255) NOT NULL,
`status` varchar(25) NOT NULL default 'published',
`sort_order` int(255) NOT NULL,
PRIMARY KEY (`district_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;


apa yang salah struktur tablenya pak??
 
View user's profile Send private message
      Back To Top  

Tue Jul 27, 2010 16:06
Author Message
andriant
Jagoan PHP
Jagoan PHP


Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
Post subject: Reply with quote
contoh hasil diatas:

jakartatimur (12 data)
pasar rebo(1), rawamangun(7), pulogadung(2), condet(2)


itu jakarta timur, jakarta pusat di group dari tabel dan field apa ya?
terus pasar rebo, rawamangun, dst itu juga digroup berdasarkan tabel dan field apa?
_________________
Lagi Boker, Makan, Mau Tidur, Coding jangan lupa baca:
PHP Manual -> http://php.net/download-docs.php
MySQL Manual -> http://dev.mysql.com/doc/
 
View user's profile Send private message Visit poster's website Yahoo Messenger
      Back To Top  

Tue Jul 27, 2010 16:08
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
kalo yang jak pusat jak timur di gruop dari table AREA
fieldnya AREA_NAME

sedangkan pasar rebo rawamangun dst
dari table NAMA trus fieldnya TEMPAT
 
View user's profile Send private message
      Back To Top  

Tue Jul 27, 2010 19:01
Author Message
andriant
Jagoan PHP
Jagoan PHP


Joined: 31 Mar 2010
Posts: 911
Location: Jakarta
Post subject: Reply with quote
kalo yang tempat si
SELECT tempat, COUNT(*) FROM nama GROUP BY tempat

boleh minta script contoh datanya sekalian tabel area den nama?
_________________
Lagi Boker, Makan, Mau Tidur, Coding jangan lupa baca:
PHP Manual -> http://php.net/download-docs.php
MySQL Manual -> http://dev.mysql.com/doc/
 
View user's profile Send private message Visit poster's website Yahoo Messenger
      Back To Top  

Wed Jul 28, 2010 11:40
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
saya mau buat yang kayak gini ni mas

http://www.yukmakan.com/directory.asp

diseblah kanannya kan ada menu browse by location...

struktur tablenya gimana y sama querynya
 
View user's profile Send private message
      Back To Top  

Mon Aug 02, 2010 02:03
Author Message
iis_holic
Anak Baru
Anak Baru


Joined: 02 Aug 2010
Posts: 1
Post subject: Reply with quote
aku punya table spt ini


gmn querynya agar tampak spt ini
 
View user's profile Send private message
      Back To Top  

Sat Aug 07, 2010 00:36
Author Message
citraalam
Anak Baru
Anak Baru


Joined: 06 Aug 2010
Posts: 4
Post subject: Reply with quote
#iis_holic

Pertanyaannya masih kurang jelas tuch? tapi kalo yang dimksud adalah cara untuk menampilkan data pada tebel diatas agar tampil di hal web kurang lebih begini.....
<?php
mysql_connect ("nama host","username","password");//masukkan sesuai dengan nama host, nama username dan password Anda
mysql_select_db ("nama database");//masukkan nama database Anda

$a="SELECT * FROM nama_tabel";
$b=mysql_query($a);
?>

<table width=\"100%\" border=\"1\">
<tr>
<td>id_proses</td>
<td>id_barang</td>
<td>urut</td>
<td>qty</td>
</tr>
<?php
while ($c=mysql_fetch_row($b)) {
echo "<tr>
<td>$c[0]</td>
<td>$c[1]</td>
<td>$c[2]</td>
<td>$c[3]</td>
</tr>";
}
?>
</table>
 
View user's profile Send private message
      Back To Top  

Sat Aug 07, 2010 00:49
Author Message
citraalam
Anak Baru
Anak Baru


Joined: 06 Aug 2010
Posts: 4
Post subject: Reply with quote
#iis_holic

maaf berhubung koneksi lambat shg image tidak tampil saat posting.
postingan diatas belum solusi.

Mo betulin tp da malem besok aja.....
 
View user's profile Send private message
      Back To Top  

Tue Aug 10, 2010 03:33
Author Message
miauw
PHP Programmer
PHP Programmer


Joined: 06 Jan 2010
Posts: 103
Post subject: Reply with quote
jangan posting sekalian gubrak Salute!
wah ntar kapan bisanya kalo mau posting nunggu besok lagi Horse Patrol
 
View user's profile Send private message
      Back To Top  
Post new topic  Reply to topic

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

      Back To Top  

Page 1 of 1
Jump to:  


Powered by phpBB © 2001, 2002 phpBB Group
Toko Kaos Couple | Avalanche style by What Is Real © 2004 | Toko Baju Butik Online | Cara Pedia | Busana Baju Muslim