kengkawan... ..ada masalah skit ler....macam mana nak select field dalam 2 table yang berasingan...aku nak display semua field yang ada dalam kedua - dua table tuh dalam satu form....mintak tolong tunjuk skit skill tuh.....

cam ner yerk.....

I assume you were referring to database table not HTML table, you need to use JOIN table SQL query to select two tables, join them and get the records of all fields. If you are using MySQL, please refer to manual at http://www.mysql.com

__________________
LiewCF | Malaysia Bloggers Forum

sori tadi....macam nih..aku guna ASP...database access....aku create 2 table...
1- table company : field ( DO,tarikh,caw,pelanggan )
2- table projek :field ( DO,tarikh,no_contrak,kuantiti)

* DO : sebagai primary key

masalahnya..aku nak joint 2 table tuh, untuk display jadi satu jerr...ia kuar camni...

contoh :
DO Tarikh Caw pelanggan
125 12/2/2005 KL ABE Enterprise

No_Contrak Kuantiti
125 200 Kg
200 350 kg


kat bawah nih...command yang aku cuba guna....contoh yang aku cari kat internet......tp dia tak nak jadi lak.....

set rs=Server.CreateObject("ADODB.recordset")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("stock.mdb") & ";"
sqlstmt = "SELECT DO,tarikh,caw,pelanggan
FROM company
INNER JOIN projek
ON Keluar.DO = projek.DO
rs.open sqlstmt, sConnString


aku harap ko faham.....

I have forgot about Access. Anyway, your sql statement is incorrect. Replace sqlstmt query string with the following:

Hope this helps.

__________________
LiewCF | Malaysia Bloggers Forum

Lcf....masih tak jadi la...boleh tak u bagi aku coding sepenuhnya yang u tahu....coding yang aku jumpa semua tak jadi....

Do you get any error message?

__________________
LiewCF | Malaysia Bloggers Forum