tumpang tanye psl html n php

pzan213 · Post time 30-1-2009 11:37 AM

thanks boardmanager..dah boleh..u r my hero..hehehe...lagi 1 kalo nak buat mcm inbox email kite tu..bile ader email bru masuk dier akan kuar bilangan kat tepi ader berape email yg bru masuk..cane ek..?

BorderManager · Post time 30-1-2009 12:55 PM

tu ko kena buat 1 field dlm database utk status email (unread,read)

lepas tu count ler $sql = "SELECT COUNT(*) FROM table WHERE email_status = 'unread'";

pzan213 · Post time 31-1-2009 03:26 AM

Originally posted by BorderManager at 30-1-2009 12:55 PM
tu ko kena buat 1 field dlm database utk status email (unread,read)

lepas tu count ler $sql = "SELECT COUNT(*) FROM table WHERE email_status = 'unread'";

hmm..kene create table baru or selitkan status email tu kat table yg tmpt simpan email tu?...so nanti mase kite send email ke org tu..kite simpan status tu as unread la ye..set default dier...pastu bile org tu dah bukak email tu dier akan set read ke?..kalo nak setkan unread tu retila sbb just masukkan default unread tu dlm code insert..tp bila user dah bace email n dier akan tukar status kepada read tu buat cane?..update status ke?

i212 · Post time 31-1-2009 09:54 AM

boleh aku tambah...
kalau nak bagi query tu laju sket... buat cenggini

$sql = "SELECT COUNT(email_status) FROM table WHERE email_status = 'unread'";

--> kita amik apa yang perlu je.. so nanti kalau data banyak... performance tak la teruk sangat..

sorry border.. menyampuk

pzan213 · Post time 31-1-2009 07:34 PM

Originally posted by i212 at 31-1-2009 09:54 AM
boleh aku tambah...
kalau nak bagi query tu laju sket... buat cenggini

$sql = "SELECT COUNT(email_status) FROM table WHERE email_status = 'unread'";

--> kita amik apa yang perlu je.. so na ...

ooo..it's ok...tq....tapi cane nak wat tu?...tul ke aper yg aku kate kat post 83 tu?

pzan213 · Post time 31-1-2009 08:46 PM

boardmanager...yg pasal popup dulu kan...kenape bile aku nak panggil data utk kuar kat popup dier tak kuar ek..tp bila aku xgune popup data tu ader plak..nape ek?

i212 · Post time 31-1-2009 09:25 PM

macam tu la...
nak bagi ok lagi.. just buat flag dgn 1 char je utk represent unread/read

cth:
U = unread
R = read

BorderManager · Post time 31-1-2009 09:59 PM

tak pun ko letak as binary je 1 0

popup yg mana n

pzan213 · Post time 31-1-2009 11:01 PM

tol ke coding ni?..penggunaan AND..

$Query="UPDATE temujanji SET status='$status' WHERE nokp = '$nokp' AND bil ='$bil' ";

i212 · Post time 31-1-2009 11:03 PM

btul la tu

nape.. tak jalan ka?

BorderManager · Post time 31-1-2009 11:03 PM

betul la tu

pzan213 · Post time 31-1-2009 11:03 PM

Originally posted by BorderManager at 31-1-2009 09:59 PM
tak pun ko letak as binary je 1 0

popup yg mana n

aku ader wat satu popup...

page 1 - page biase
page 2 - aku wat popup...

so data2 yg aku masukkan nak dipaparkan pada popup..kirenye aku post la data tu...tp apesal data tu tak kuar ek kat popup....

tp kalo aku gantikan page 2 tu kpd page biase...data tu kuar plak..

i212 · Post time 1-2-2009 11:20 AM

mendap ka thread nih?

pzan213 · Post time 1-2-2009 11:40 AM

Originally posted by i212 at 31-1-2009 11:03 PM
btul la tu

nape.. tak jalan ka?

jalan tu jln...tp dier xupdate dlm database..tp bile aku buang bil tu..dier update...tp dier update smua skali status yg punya ic yg sama...

i212 · Post time 1-2-2009 01:05 PM

cuba check $bil tu ada value ke tak...

pzan213 · Post time 1-2-2009 06:58 PM

dah post dah value tu dr page sblm tu...

i212 · Post time 2-2-2009 10:08 AM

value tu sampai ke tak?...
cuba try test uji bubuh echo $bil tgk... ada value tak...

pzan213 · Post time 2-2-2009 12:38 PM

dah isi pun bil tu...tp tu yg pelik dier tak update...hmmm...

i212 · Post time 2-2-2009 02:24 PM

bil tu type ape?
Char ke atau Integer?

cuba buang tanda (') tu utk bil... ..

$Query="UPDATE temujanji SET status='$status' WHERE nokp='$nokp' AND bil=$bil ";