saya ada buat satu db. tapi bila saya buat coding kat bawah nih... keluar error... mula2 saya buat camni takde masalah:
$result = mysql_query("SELECT * from personal WHERE emp_id=$pwd");
Tapi bila tambah cam kat bwh nih keluar error..

<?php

$result = mysql_query("SELECT * from personal WHERE emp_id=$pwd AND emp_name=$name");

while ($row = mysql_fetch_object($result)) {
?><p>

Name : <?php echo $row->emp_name; ?><br>
IC : <?php echo $row->emp_ic; ?><br>
Gender : <?php echo $row->emp_gender; ?><br>
Status : <?php echo $row->emp_status; ?><br>
Address : <?php echo $row->emp_address; ?><br>
Phone : <?php echo $row->emp_phone; ?><br>
Last Login Date: <?php echo $row->emp_logdate; ?><br>
<?php
}
mysql_free_result($result);


?>



Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in c:\web\sys\empsys\personal_info.php on line 5

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\web\sys\empsys\personal_info.php on line 17

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

progmania:

cuba check the sql query "SELECT * from personal WHERE emp_id=$pwd" ... ada tak salah eja table name atau column name...

yg keduanya, tambahkan 'single quotes' pada $pwd dan $name, macam ni:

__________________
blog:zaim_bakar_blog | biz:box

semua nama,table,colum,var dlm tu betul... dah cuba dah tambah tanda ' error tak keluar tapi data dlm database pun tak keluar gak... kosong je....

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

ok problem solve (change whole coding).... tapi nak tanya boleh tak kalau nak buat cam coding kat atas tu

$result = mysql_query("SELECT * from personal WHERE emp_id=$pwd AND emp_name=$name");

tapi panggil sekali 2 table. contoh table personal dan company, pastu display sekali....

TQ...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!

boleh, gunakan dot notation, macam ini: cara ni selalunya digunakan kalau dua-dua table ada link (menggunakan primary/foreign key), contohnya: sorrylah kalau tak paham sebab aku pun bukannya expert dalam SQL...

link utk belajar SQL: http://www.w3schools.com/sql/default.asp

__________________
blog:zaim_bakar_blog | biz:box

ok thank you.... dah jadi memang saya ader pakai primary key pun....walaupun ader skit error tapi rasernyer boleh di modify sendiri... thanks Zaimlah...

__________________
Set the goal, push to the limit, reach the top and u'll be proud.. Try lah!