hi
im having major problems deleting multiple messages from the guestbook i
have created
im new to php so any replies to this problem will have to easy for me to
understand
i have got my guestbook reading and showing entries and have added
checkboxes under each entry for the deletion process
heres what it looks like:
while ($rows = mysql_fetch_array($result)) {
$id = $rows["id"];
$firstname = $rows["first_name"];
$lastname = $rows["last_name"];
///////////////////////////////////////////////////////////////
//// ACCESS THE DATABASE'S timestamp RECORD TO SHOW DATE AND
//// TIME ENTRIES WERE MADE
//////////////////////////////////////////////////////////////
$db_date = $rows['time'];
$yr = substr($db_date, 0, 4);
$mon = substr($db_date,4,2);
$day = substr($db_date,6,2);
$hour = substr($db_date,8,2);
$min = substr($db_date,10,2);
$sec = substr($db_date,12,2);
$orgdate = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));
?>
<?///////////////////////////////////////////////////////////////?>
<? //TABLE TO SHOW THE CONTENTS OF USER_MESSAGE DATABASE TABLE ?>
<?///////////////////////////////////////////////////////////////?>
<HTML>
<HEAD>
<TITLE>Queen Vic Message Book</TITLE>
</HEAD>
<BODY>
<FORM METHOD="post" ACTION="delete.php">
<P><TABLE BORDER="1" WIDTH="600" BORDERCOLOR=#F00000>
<TR>
<b>Date/Time Posted:</b> <? echo $orgdate; ?>
</TR>
<TR>
<TD><b>Name:</b> <? echo $rows['name']; ?></TD>
<TD><b>Email:</b> <A HREF="mailto:<? echo $rows['email']; ?>">
<? echo $rows['email']; ?></TR></TD>
<TR><TD COLSPAN="4">
<? echo $rows['message']; ?>
</TD></TR>
</TABLE>
<TD>
<b>Delete Message</b> <input type="checkbox" name="id[]" value="$id">
</TD>
</P>
</BODY>
</HTML>
<?/////////////////////////////////////////////////////////////////?>
<?//// CLOSES LOOP CREATED FOR ADDING DATA TO TABLE?>
<?/////////////////////////////////////////////////////////////////?>
<? } ?>
i have tried to make the value of the checkbox the message id (is this
right?)
what do i need to do next
please help i have to hand this project in soon :(
php script is attached and if anyone can look at it and sort it for me i
would appreciate it very much
(thejack@btinternet.com) send working script there please :D
thanks
begin 666 deletemess.php
M#0H\/PT*#0HO+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\-"B\O+R\@1$5&24Y%(%9!4DE!
M0DQ%4R!&3U(@9&%T86)A<V4L('1A8FQE+"!C;VYN96-T:6]N($%.1"!72$E#
M2" -"B\O+R\@9&%T86)A<V4@5$\@0T].3D5#5"!43PT*+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O#0H-"B1D8E]N86UE(#T@(G1E<W1D8B([#0H-"B1T86)L95]N86UE
M(#T@(G5S97)?;65S<V%G92([#0H-"B1C;VYN96-T:6]N(#T@0&UY<W%L7V-O
M;FYE8W0H(FQO8V%L:&]S="(L(")M87)K(BP@(G1R=7-T;F\Q(BD@#0H);W(@
M9&EE*")#;W5L9&XG="!C;VYN96-T+B(I.PT*#0HD9&(@/2!M>7-Q;%]S96QE
M8W1?9&(H)&1B7VYA;64L("1C;VYN96-T:6]N*0T*"6]R(&1I92@B0V]U;&1N
M)W0@<V5L96-T(&1A=&%B87-E+B(I.PT*#0H-"B\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+PT*
M+R\O+R!1545262!43R!)3E-%4E0@5D%,5453($]&(%1(12!G=65S=&)O;VM?
M9F]R;2!)3E1/(%1(12 -"B\O+R\@=7-E<E]M97-S86=E(%1!0DQ%#0HO+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+PT*( T*:68@*"@D;F%M92 A/2 B(BD@?'P@*"1E;6%I;" A
M/2 B(BD@?'P@*"1M97-S86=E("$]("(B*2D@>PT*#0HD<W%L7W%U97)Y(#T@
M(DE.4T525"!I;G1O("1T86)L95]N86UE#0HH;F%M92P@96UA:6PL(&UE<W-A
M9V4I#0I604Q515,@#0HH7"(D;F%M95PB+"!<(B1E;6%I;%PB+%PB)&UE<W-A
M9V5<(BD-"B([#0H-"B1S<6Q?<75E<GD@/2 B24Y315)4(&EN=&\@)'1A8FQE
M7VYA;64-"BAI9"P@;F%M92P@96UA:6PL(&UE<W-A9V4I#0I604Q515,@#0HH
M7")I9%PB+"!<(B1N86UE7"(L(%PB)&5M86EL7"(L7"(D;65S<V%G95PB*0T*
M(CL-"@T*#0H-"@T*#0H-"@T*+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O#0HO+R\O
M(%-43U)%(%1(12!215-53%0@3T8@5$A%($%"3U9%(%%515)9($E.5$\@5$A%
M(%9!4DE!0DQ%("1R97-U;'0-"B\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+PT*#0HD
M<F5S=6QT(#T@;7ES<6Q?<75E<GDH)'-Q;%]Q=65R>2P@)&-O;FYE8W1I;VXI
M;W(-"F1I92@B0V]U;&1N)W0@17AE8W5T92!1=65R>2(I.R -"GT-"B\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O#0HO+R\O($E&(%-50T-%4U-&54Q,($1)4U!,05D@
M5$A%($9/3$Q/5TE.1R!-15-304=%#0HO+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O#0H-
M"F5C:&\@(CQB/E1H86YK<R!F;W(@<W5B;6ET=&EN9R!T;R!O=7(@9W5E<W1B
M;V]K/"]B/B([#0H-"C\^#0H-"@T*/#\-"@T*#0HO+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\-"B\O+R\@455%4ED@5$\@0T]53E0@5$]404P@3E5-0D52($]&($5.5%))
M15,@34%$10T*+R\O+R!35$]212!1545262!215-53%0@24X@)&YU;5]G=65S
M="!605))04),10T*+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\-"@T*)&-O=6YT7W%U97)Y
M(#T@(E-%3$5#5"!#3U5.5"@J*2!&4D]-("1T86)L95]N86UE(CL-"B1G=65S
M=%]N=6T@/2!M>7-Q;%]Q=65R>2@D8V]U;G1?<75E<GDI(&]R#0H)9&EE*")3
M96QE8W0@1F%I;&5D(BD[#0HD;G5M7V=U97-T(#T@;7ES<6Q?9F5T8VA?87)R
M87DH)&=U97-T7VYU;2D[#0H-"C\^#0H-"CP_+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O/SX-
M"CP_+R\O+R!$25-03$%9(%1/(%-#4D5%3B!43U1!3"!.54U"15(@3T8@14Y4
M4DE%4R!!4R!)1$5.5$E&245$/SX-"CP_+R\O+R!"62!!0D]612!1545262 M
M+2!(65!%4DQ)3DL@241%3E1)1DE%4R!605))04),12 B8V]M<&QE=&5?;65S
M<V%G92(_/@T*/#\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\_/@T*#0H\4#X-"CQ!($A2148]
M(F=U97-T8F]O:RYP:' _8V]M<&QE=&5?;65S<V%G93TQ(CX-"CP_(&5C:&\@
M)&YU;5]G=65S=%LP73L@/SX@<&5O<&QE(&AA=F4-"FQE9G0@82!M97-S86=E
M+CPO03X@/&(^*&-L:6-K(&QI;FL@=&\@=FEE=R!F=6QL(&QI<W0A*3PO8CX-
M"CPO4#X-"@T*#0H\/PT*#0H-"B\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\-"B\O+R\@35E344P@
M4U1!5$5-14Y4(%1/(%-%3$5#5"!!3$P@1DE%3$13($923TT@=7-E<E]M97-S
M86=E( T*+R\O+R!T86)L92!/4B!*55-4(#$U($U/4U0@4D5#14Y4($5.5%))
M15,-"B\O+R\@0TQ)0TM)3D<@3TX@5$A%($A94$523$E.2R!!0U1)5D%415,@
M5$A%(&-O;7!L971E7VUE<W-A9V4@#0HO+R\O(%9!4DE!0DQ%(%1(15)%1D]2
M12!44DE'1T5224Y'($9)4E-4(%%515)9("@J($U%4U-!1T53*0T*+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+PT*#0II9B H)&-O;7!L971E7VUE<W-A9V4@/3T@,2D@>PT*"21S
M<6Q?<75E<GD@/2 B4T5,14-4("H@1E)/32 D=&%B;&5?;F%M92!/4D1%4B!"
M62!T:6UE($1%4T,B.PT*?2!E;'-E('L-"@DD<W%L7W%U97)Y(#T@(E-%3$5#
M5" J($923TT@)'1A8FQE7VYA;64@3U)$15(@0ED@=&EM92!$15-#($Q)34E4
M(#$U(CL-"GT-"@T*+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O#0HO+R\O(%-43U)%(%1(
M12!/551#3TU%($]&(%1(12!!0D]612!1545262!)3B!605))04),12 B)')E
M<W5L="(-"B\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+PT*#0HD<F5S=6QT(#T@;7ES<6Q?
M<75E<GDH)'-Q;%]Q=65R>2EO<B -"@ED:64@*")C86YN;W0@97AE8W5T92!Q
M=65R>2(I.PT*#0HO+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+PT*+R\O+R!,3T]0(%1(4D]5
M1T@@1DE%3$13(%1/($-/3E1)3E5/55-,62!21512245612!$051!($923TT@
M#0HO+R\O('5S97)?;65S<V%G92!T86)L90T*+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+PT*
M#0H-"G=H:6QE("@D<F]W<R ](&UY<W%L7V9E=&-H7V%R<F%Y*"1R97-U;'0I
M*2![#0H-"B1I9" ]("1R;W=S6R)I9")=.PT*)&9I<G-T;F%M92 ]("1R;W=S
M6R)F:7)S=%]N86UE(ET[#0HD;&%S=&YA;64@/2 D<F]W<ULB;&%S=%]N86UE
M(ET[#0H-"@T*#0HO+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\-"B\O+R\@04-#15-3(%1(
M12!$051!0D%312=3('1I;65S=&%M<"!214-/4D0@5$\@4TA/5R!$051%($%.
M1 T*+R\O+R!424U%($5.5%))15,@5T5212!-041%#0HO+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+PT*#0HD9&)?9&%T92 ]("1R;W=S6R=T:6UE)UT[#0HD>7(@/2!S=6)S
M='(H)&1B7V1A=&4L(# L(#0I.PT*)&UO;B @/2!S=6)S='(H)&1B7V1A=&4L
M-"PR*3L-"B1D87D@(#T@<W5B<W1R*"1D8E]D871E+#8L,BD[#0HD:&]U<B ]
M('-U8G-T<B@D9&)?9&%T92PX+#(I.PT*)&UI;B @/2!S=6)S='(H)&1B7V1A
M=&4L,3 L,BD[#0HD<V5C(" ]('-U8G-T<B@D9&)?9&%T92PQ,BPR*3L-"B1O
M<F=D871E(#T@9&%T92@B;"!&(&13+"!9(&@Z:2!!(BQM:W1I;64H)&AO=7(L
M)&UI;BPD<V5C+"1M;VXL)&1A>2PD>65A<BDI.PT*#0H_/@T*#0H\/R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+S\^#0H\/R O+U1!0DQ%(%1/(%-(3U<@5$A%($-/3E1%
M3E13($]&(%5315)?34534T%'12!$051!0D%312!404),12 _/@T*/#\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\_/@T*#0H\2%1-3#X-"CQ(14%$/@T*/%1)5$Q%/E%U
M965N(%9I8R!-97-S86=E($)O;VL\+U1)5$Q%/@T*/"](14%$/@T*/$)/1%D^
M#0H\1D]232!-151(3T0](G!O<W0B($%#5$E/3CTB9&5L971E+G!H<"(^#0H-
M"@T*/% ^/%1!0DQ%($)/4D1%4CTB,2(@5TE$5$@](C8P,"(@0D]21$520T],
M3U(](T8P,# P,#X-"@T*/%12/@T*/&(^1&%T92]4:6UE(%!O<W1E9#H\+V(^
M(#P_(&5C:&\@)&]R9V1A=&4[(#\^#0H\+U12/@T*#0H\5%(^#0H\5$0^/&(^
M3F%M93H\+V(^(#P_(&5C:&\@)')O=W-;)VYA;64G73L@/SX\+U1$/@T*#0H\
M5$0^/&(^16UA:6PZ/"]B/B )/$$@2%)%1CTB;6%I;'1O.CP_(&5C:&\@)')O
M=W-;)V5M86EL)UT[(#\^(CX-"@D)"3P_(&5C:&\@)')O=W-;)V5M86EL)UT[
M(#\^/"]44CX\+U1$/@T*#0H-"@T*/%12/CQ41"!#3TQ34$%./2(T(CX-"CP_
M(&5C:&\@)')O=W-;)VUE<W-A9V4G73L@/SX-"CPO5$0^/"]44CX-"CPO5$%"
M3$4^#0H\5$0^#0H\8CY$96QE=&4@365S<V%G93PO8CX@/&EN<'5T('1Y<&4]
M(F-H96-K8F]X(B!N86UE/2)I9%M=(B!V86QU93TB)&ED(CX-"CPO5$0^#0H\
M+U ^#0H\+T)/1%D^#0H\+TA434P^#0H-"CP_+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\_/@T*/#\O+R\O($-,3U-%4R!,3T]0($-214%4140@1D]2($%$1$E.1R!$
M051!(%1/(%1!0DQ%/SX-"CP_+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O
M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\_/@T*/#\@
M?2 _/@T*/$E.4%54(%194$4](G-U8FUI="(@3D%-13TB9&5L971E(B!604Q5
M13TB1&5L971E($UE<W-A9V5S(CX-"CQ0/CQA(&AR968](F=U97-T8F]O:U]F
G;W)M+FAT;6PB/D%D9"!!;F]T:&5R($UE<W-A9V4\+V$^/"]P/@T*
`
end
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
