Forum › Internet Service & Networking › tumpang tanye psl html n php

pzan213 Publish 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..?:o

BorderManager Publish 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 Publish time 31-1-2009 03:26 AM

Originally posted by BorderManager at 30-1-2009 12:55 PM http://eforum5.cari.com.my/images/common/back.gif
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 Publish time 31-1-2009 09:54 AM

Balas #82 BorderManager\ catat

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 Publish time 31-1-2009 07:34 PM

Originally posted by i212 at 31-1-2009 09:54 AM http://eforum5.cari.com.my/images/common/back.gif
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 Publish 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 Publish time 31-1-2009 09:25 PM

Balas #85 pzan213\ catat

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

cth:
U = unread
R = read

BorderManager Publish time 31-1-2009 09:59 PM

tak pun ko letak as binary je 1 0

popup yg mana n

pzan213 Publish time 31-1-2009 11:01 PM

tol ke coding ni?..penggunaan AND..

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

i212 Publish time 31-1-2009 11:03 PM

Balas #89 pzan213\ catat

btul la tu

nape.. tak jalan ka?

BorderManager Publish time 31-1-2009 11:03 PM

betul la tu

pzan213 Publish time 31-1-2009 11:03 PM

Originally posted by BorderManager at 31-1-2009 09:59 PM http://eforum5.cari.com.my/images/common/back.gif
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 Publish time 1-2-2009 11:20 AM

mendap ka thread nih?

pzan213 Publish time 1-2-2009 11:40 AM

Originally posted by i212 at 31-1-2009 11:03 PM http://eforum5.cari.com.my/images/common/back.gif
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 Publish time 1-2-2009 01:05 PM

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

pzan213 Publish time 1-2-2009 06:58 PM

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

i212 Publish time 2-2-2009 10:08 AM

Balas #96 pzan213\ catat

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

pzan213 Publish time 2-2-2009 12:38 PM

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

i212 Publish time 2-2-2009 02:24 PM

bil tu type ape?
Char ke atau Integer?

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

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

pzan213 Publish time 2-2-2009 02:35 PM

ha'a..lupe lak..kalo bil tu integer xyah isi ' ' kan?

View full version: tumpang tanye psl html n php