macam mana nak buat sesuatu data tu visible n invisible?contoh,

jika sebuah file mempunyai peminjam,

nama fail tersebut akan dikaburkan atau tidak aktif kerana fail tersebut mempunyai peminjam.

apabila peminjam tersebut memulangkan fail,

nama fail tersebut boleh dipilih atau sudah aktif..

Create an additional field/column in the database table, i.e. the Active field.

If it's active, the Active field = 1.
If it's inactive, the Active field = 0.

So that, the page will make use of the Active field to query a set of data for active status only and vice-versa.

maksudnye?

create 1 field dalam table yang ada file name ke?

prosesnya nak buat macam mana?

if the field in the book table is set to 1 then the book have been borrow lah...
if borrow oledi don't list it out lar....
if book have been returned set the field back to 0 ...
if returned book then list it out loh...

the idea have been given by genzy is quite clear already lar...
in programming you need to really define your own logic, algorithm and coding alot lar...

don't be so pemalas lar.... everytime need to spoon feed meh...

__________________
Freelance Jobs Post
Get Motivated Daily

ok,thanks..i try k

genzy..saya mintak tolong sgt ni..present saya selasa depan..kalau boleh saya nak dapatkan logik tu..tapi saya betul-betul tak tau macam mana nak buat coding tu..boleh awak bantu saya?atau beri website yang boleh saya rujuk untuk coding ni

References:
SQL UPDATE
SQL INSERT INTO

jika sebuah file mempunyai peminjam, nama fail tersebut akan dikaburkan atau tidak aktif kerana fail tersebut mempunyai peminjam.
=>

When the borrow form is submitted by the borrower,

-- Update the book status to be inactive.
UPDATE BOOK
SET ACTIVE = 0
WHERE BOOK_ID = 1234 AND BORROWER = 'ALI'

PHP to execute UPDATE SQL
PHP SQL Update Query

apabila peminjam tersebut memulangkan fail, nama fail tersebut boleh dipilih atau sudah aktif..
=>
When the return form is submitted by the borrower,

-- Update the book status to be active.
UPDATE BOOK
SET ACTIVE = 1
WHERE BOOK_ID = 1234 AND BORROWER = ''

-- Log the book borrowing history.
INSERT INTO BORROW_HISTORY(BOOK_ID, BORROWER, RETURNED_DATE)
VALUES (1234, 'ALI', '2007-7-4 04:13:54')

PHP to execute INSERT SQL
PHP SQL Insert Query

MySQL AB :: MySQL 5.0 Reference Manual :: 12.6 Date and Time Functions
Date and Time in MySQL 5

tq genzy..harap code awk ni dpt membantu sy siapkan sistem ni..amin

tak tau... otai tolong sket...