Help please
I enclose my code examples of two pages. One to gert search data from a
user which uis POSTed to the second page where it's validated and displayed.
The prev/next only works for the first 20 records.
When i click next, my page reloads and re applies my validation rules and
outputs the error messages to the user asking for valid input.
What am i doing wromng???
Thanks for any help
begin 666 myquery.txt
M/#\-"B\O+R\O+R\O+R\O+R\O+R\O+R\O+R\@("!004=%(#$@(" O+R\O+R\O
M+R\-"B\O(&1A=&$@96YT<GD@9F]R;2XN+G!A9V4@;F%M92 B9&%T85]E;G1R
M>2YP:' B#0H-"B\O(&5X=')A8W0@;V8@=&AE(&1A=&$@9F]R;2XN=&AE<F4@
M87)E(&UO<F4@9FEE;&1S(&EN(')E86QI='D-"@DD9F]R;2 ](CQ"4CX\8V5N
M=&5R/CQT86)L92!W:61T:" ](%PB-C P7"(@/$)2/B \9F]R;2!N86UE(#U<
M(F9O<FU<(B!M971H;V0@/2=P;W-T)R!A8W1I;VX])W)E<W5L=',N<&AP)SXB
M.PT*"21F;W)M("X](CQ"4CY%;G1E<B!Y;W5R('-E87)C:"!C<FET97)I82!I
M;B!T:&4@9FEE;&1S(&)E;&]W+B([#0H))&9O<FTN/2(\<#Y3=7)N86UE.B @
M(" @(CL-"@DD9F]R;2X](CQB<CX\:6YP=70@='EP93U<(G1E>'1<(B!N86UE
M/5PB<W5R;F%M95PB('-I>F4]7"(V-5PB(&UA>&QE;F=T:#U<(C4P7"(B.PT*
M"21F;W)M+CTB=F%L=64]7"(D<W5R;F%M95PB/B9N8G-P.R9N8G-P.R9N8G-P
M.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R([#0H))&9O<FTN/2(\8G(^1FER
M<W1N86UE.B @(CL-"@DD9F]R;2X](CQB<CX\:6YP=70@='EP93U<(G1E>'1<
M(B!N86UE/5PB9FER<W1N86UE7"(@<VEZ93U<(C8U7"(@;6%X;&5N9W1H/5PB
M-3!<(B([#0H))&9O<FTN/2)V86QU93U<(B1F:7)S=&YA;65<(CXB.PT*"21F
M;W)M+CTB/&)R/D5M86EL($%D9')E<W,Z(" @(CL-"@DD9F]R;2X](CQB<CX\
M:6YP=70@='EP93U<(G1E>'1<(B!N86UE/5PB96UA:6Q<(B!S:7IE/5PB-C5<
M(B!M87AL96YG=&@]7"(W,%PB(CL-"@DD9F]R;2X](G9A;'5E/5PB)&5M86EL
M7"(^(CL-"@DD9F]R;2X](CQB<CX\:6YP=70@='EP93U<(G-U8FUI=%PB('9A
M;'5E/5PB4V5A<F-H7"(@/B([#0H))&9O<FTN/2(\8G(^/"]T9#X\+W1R/CPO
M=&%B;&4^(CL-"@DD9F]R;2X](CPO9F]R;3XB.PD-"@D-"@EE8VAO*"1F;W)M
M*3L-"GT[/SX-"CQS8W)I<'0@;&%N9W5A9V4](DIA=F%38W)I<'0B/B -"F1O
M8W5M96YT+F9O<FTN<W5R;F%M92YF;V-U<R@I.R -"CPO<V-R:7!T/B -"@T*
M#0H\/PT*#0HO+R!4:&ES(&ES('1H92!R97-U;'1S('!A9V4N+BYP86=E(&YA
M;64@(G)E<W5L=',N+G!H<"(-"@T*+R\@9&(@8V]N;F5C=&EO;B!D871A(&EN
M8VQU9&5D(&AE<F4-"@T*+R\@<W1A<G0@)'%U97)Y(&]F9@T*)'%U97)Y(#T@
M(G-E;&5C=" J(&9R;VT@;7E486)L92!W:&5R92 B.PT*"0T*"0D)"2\O('1H
M97)E('1H96X@9F]L;&]W(&$@<V5R:65S(&]F(&9I96QD(&-H96-K:6YG('1O
M('-E92!W:&%T)W,@8F5E;B!F:6QL960@:6X@971C#0H)"0D)+R\@8VAE8VMS
M('1O('-E92!T:&%T(&UO<F4@=&AA;B!O;F4@9FEE;&0@:&%S(&)E96X@8V]M
M<&QE=&5D+B @:&5R92!I<R!A;B!E>&%M<&QE(&]F(&]N;'D@,R!F:65L9',N
M("!);B!R96%L:71Y('1H97)E(&%R92!M;W)E(&9I96QD<RX-"@D)"0T*"0D)
M:68@*"@A)'-U<FYA;64I("8F("@A)&9I<G-T;F%M92D@)B8@*"$D96UA:6PI
M("D-"@D)"7L-"@D)"0EE8VAO("@B/' ^/&)R/CQB<CY9;W4@:&%V92!N;W0@
M8V]M<&QE=&5D(&%N>2!F:65L9',N(" \<#Y9;W4@8V%N('-E87)C:"!B>2!%
M+4UA:6P@=VET:&]U="!E;G1E<FEN9R!F=7)T:&5R(&-R:71E<FEA(&EF('EO
M=2!W:7-H+CQP/EEO=2!C86YN;W0@<V5A<F-H(&]N(%-U<FYA;64L($9I<G-T
M($YA;64@=VET:&]U="!E;G1E<FEN9R!M;W)E(&EN9F]R;6%T:6]N+CQP/D9I
M96QD<R!M=7-T(&-O;G1A:6X@870@;&5A<W0@,B!C:&%R86-T97)S+CQP/EEO
M=2!C86X@=7-E(&$@=VEL9"!C87)D('-E87)C:"!B>2!P;&%C:6YG('1H92 J
M(&-H87)A8W1E<B!A="!T:&4@96YD(&]F('1H92!T97AT+CQP/E!L96%S92!G
M;R \82!H<F5F/5PB:F%V87-C<FEP=#IH:7-T;W)Y+F)A8VLH*5PB/F)A8VL\
M+V$^('1O('1H92!S96%R8V@@<&%G92XB*3L-"@D)"65X:70H*3L-"@D)"7T-
M"@T*:68@*"1S=7)N86UE*2![8VAE8VM?;&5N9W1H*"1S=7)N86UE*3M]#0HO
M+R!T:&ES(&ES(&%N(&5X86UP;&4L('1H97)E(&%R92!M;W)E(&EN(')E86QI
M='D-"@T*+R\@=&AI<R!J=7-T(&-H96-K<R!T:&4@;G5M8F5R(&]F(&-H87)A
M8W1E<G,@86YD(&9O<F-E<R!U<V5R(&)A8VL@:68@=&AE<F4@87)E('1O;R!F
M97<N#0H-"@T*:68@*"1S=7)N86UE*2 -"@D)>R ):68@"2@H)&9I<G-T;F%M
M92D@?'P@*"1E;6%I;"DI+R\@:68@=&AE<F4@:7,@86YO=&AE<B!F:65L9"!C
M;VUP;&5T960N+BX-"@D)"7L))&%N9" ]("(@86YD("([('T-"@D)"0EE;'-E
M#0H)"0E[( DD86YD(#T@(B(["7T-"@D)8VAE8VM?<W1A<B@D<W5R;F%M92P@
M)&%N9"P@)'!A<G0L(")S=7)N86UE(B I.R\O(&9U;F-T:6]N('1O(&-R96%T
M92!T:&4@<75E<GD-"@D)?0T*#0H-"B\O('1H:7,@:7,@86X@97AA;7!L92!O
M9B!H;W<@:2!B=6EL9"!T:&4@979E;G1U86P@<75E<GDN("!497-T<R!T;R!S
M964@=VAA="!F:65L9',@:&%V92!B965N(&-O;7!L971E9"XN#0HO+R!A;F0@
M8V]N<W1A;G1L>2!A9&1S('1O('1H92!Q=65R>2!S=')I;F<L(&5V96YT=6%L
M;'D@<')O9'5C:6YG(&$@=F%L:60@)'%U97)Y+@T*+R\@92YG(%-%3$5#5" J
M($923TT@;7E486)L92!72$5212!S=7)N86UE(#T@)W1E<W13=7)N86UE)R!A
M;F0@9FER<W1N86UE(#T@)W1E<W1&:7)S=&YA;64G(&%N9"!E;6%I;" ]("=T
M97-T16UA:6PG(&5T8PT*#0HO+R!F<F]M(&AE<F4@;VX@:7,@=VAE<F4@22!I
M;G-E<G1E9"!T:&4@<V%M<&QE(&-O9&4@=&\@=')Y(&%N9"!D:7-P;&%Y(')E
M<W5L=',@:6X@8FQO8VMS('5S:6YG(%!2158@86YD($Y%6%0L(&%N9"!I="=S
M(&AE<F4@:2!S=')U9V=L90T*("1L:6UI=#TR,#L@#0H@(" @(" @(" @(" D
M4')E=B ](")0<F5V:6]U<R([( T*(" @(" @(" @(" @)$YE>'0@/2 B3F5X
M="([( T*#0H@(" @(" @(" @(" D;G5M<F5S=6QT<SUM>7-Q;%]Q=65R>2@D
M<75E<GDI.R -"@D)"65C:&\H(DY532!215-53%0@)&YU;7)E<W5L=',B*3L-
M"B @(" @(" @(" @("1N=6UR;W=S/6UY<W%L7VYU;5]R;W=S*"1N=6UR97-U
M;'1S*3L@#0H-"B @(" @(" @(" @(&EF("AE;7!T>2@D;V9F<V5T*2D@>R -
M"B @(" @(" @(" @("1O9F9S970],#L@#0H@(" @(" @(" @("!]( T*#0H-
M"B @(" @(" @(" @(&5C:&\@(CQT86)L92!W:61T:#TQ,# E(&)G8V]L;W(]
M(T9&1D9&1B!B;W)D97(],"!C96QL<&%D9&EN9STR( T*(" @(" @(" @(" @
M8V5L;'-P86-I;F<],CXB.R -"@D)"21S<6P@/2 D<75E<GD[( T*"0D)96-H
M;R@B)%-13"!)4R D<W%L(BD[#0H@(" @(" @(" @(" D<W%L("X]("(@;&EM
M:70@)&]F9G-E="PD;&EM:70@(CL@#0H)"0D-"@D)"0EE8VAO*"(\8G(^)%-1
M3"!)4R!N;W<@)'-Q;"(I.PT*(" @(" @(" @(" @)')E<W5L=" ](&UY<W%L
M7W%U97)Y*"1S<6PL)&-O;FXI(&]R(&1I92@B0V]U;&0@;F]T(&5X96-U=&4@
M#0H@(" @(" @(" @("!Q=65R>2XB*3L@#0H@(" @(" @(" @("!W:&EL92 H
M)')O=R ](&UY<W%L7V9E=&-H7V%R<F%Y*"1R97-U;'0I*2![( T*#0H@(" @
M(" @(" @("!E8VAO("(@#0H@(" @(" @(" @(" \='(@8F=C;VQO<CTC0T-#
M0T-#/CQT9#X\9F]N="!C;VQO<CTC,# P,# P( T*(" @(" @(" @(" @<VEZ
M93TQ/CQB/B1R;W=;<W5R;F%M95U<(B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P
M.UPB)')O=UMF:7)S=&YA;65=7"(F;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#M<
M(B1R;W=;96UA:6Q=/"]B/CPO9F]N=#X\+W1D/CPO='(^( T*(" @(" @(" @
M(" @(CL@#0H@(" @(" @(" @("!]( T*(" @(" @(" @(" @;7ES<6Q?9G)E
M95]R97-U;'0H)')E<W5L="D[( T*#0H-"B @(" @(" @(" @(&5C:&\@(CPO
M=&%B;&4^(CL@#0H-"@T*(" @(" @(" @(" @)'!A9V5S/6EN='9A;"@D;G5M
M<F]W<R\D;&EM:70I.R -"@T*(" @(" @(" @(" @:68@*"1N=6UR;W=S)21L
M:6UI="D@>R -"B @(" @(" @(" @("1P86=E<RLK.R -"B @(" @(" @(" @
M('T@#0H-"B @(" @(" @(" @(&9O<B H)&D],3LD:3P])'!A9V5S.R1I*RLI
M('L@#0H@(" @(" @(" @(" D;F5W;V9F<V5T/21L:6UI="HH)&DM,2D[( T*
M(" @(" @(" @(" @<')I;G0@(CQA(&AR968]7"(D4$A07U-%3$8_;V9F<V5T
M/21N97=O9F9S971<(CXD:3PO83X@7&XB.R -"B @(" @(" @(" @('T@#0H-
M"@T*(" @(" @(" @(" @:68@*"1O9F9S970^,2D@>R -"B @(" @(" @(" @
M("1P<F5V;V9F<V5T/21O9F9S970M)&QI;6ET.R -"B @(" @(" @(" @('!R
M:6YT("(\82!H<F5F/5PB)%!(4%]314Q&/V]F9G-E=#TD<')E=F]F9G-E=%PB
M/B10<F5V/"]A/B!<;B([( T*(" @(" @(" @(" @?2 -"@T*#0H@(" @(" @
M(" @("!I9B H)&YU;7)O=W,^*"1O9F9S970K)&QI;6ET*2D@>R -"B @(" @
M(" @(" @("1N97AT;V9F<V5T/21O9F9S970K)&QI;6ET.R -"B @(" @(" @
M(" @('!R:6YT("(\82!H<F5F/5PB)%!(4%]314Q&/V]F9G-E=#TD;F5X=&]F
M9G-E=%PB/B1.97AT/"]A/CQP/EQN(CL@#0H)"0E]#0HO*@T*5VAE;B!Y;W4@
M96YT97(@82!S=7)N86UE(&]N('1H92!D871A7V5N=')Y(&9O<FT@86YD(&-L
M:6-K('-E87)C:"P@=&AE(')E8V]R9',@87)E(')E='5R;F5D('1O('1H92!L
M:6UI="!O9B R,"!A<R!I<R!S970@86)O=F4L(&)U="!W:&5N(&D@8VQI8VL@
M;VX@3D585"P@22!S964@;7D@8W5S=&]M97(@97)R;W(@;65R<W-A9V4@<')O
M;71I;F<@;64@=&\@9FEL;"!I;B!O;F4@;V8@=&AE(&9I96QD<RX@(%=H96X@
M=&AE(&9O<FT@<F5L;V%D<R!I='-E;&8L("A02%!?4T5,1BD@:70@<G5N<R!T
M:')O=6=H('1H92!V86QI9&%T:6]N(&-H96-K<R!A9V%I;B!W:&EC:"!I;B!T
M=7)N('-P;VEL<R!T:&4@;W5T<'5T+@T*#0I4:&5R92!M=7-T(&)E(&$@8F5T
M=&5R('=A>2!T;R!D;R!T:&ES+"!B=70@22!H879E(&]N;'D@8F5E;B!F86-E
M9"!W:71H(&1I<W!L87EI;F<@82!F97<@<V5A<F-H(')E<W5L=',N("!.;W<@
M22!A;2!W;W)K:6YG(&]N('-O;65T:&EN9R!W:&EC:"!N965D<R!T:&4@9F%C
M:6QI='D@=&\@9&ES<&QA>2!M86YY(')E<W5L=',@:6X@8FQO8VMS(&]F(#(P
M(&]R('-O+@T*#0I1=65S=&EO;CH@($ES('1H97)E(&$@=V%Y('1O(&9I>"!T
M:&EN9W,@=&AE('=A>2!)(&AA=F4@9&]N92!T:&5M/PT*#0I)9B!N;W0L(&-A
M;B!A;GEO;F4@<W5G9V5S="!A(&)E='1E<B!W87D@=&\@:&%N9&QE('1H92!S
M96%R8V@@8W)I=&5R:6$@9G)O;2!T:&4@=7-E<BP@=F%L:61A=&EN9R!I="!E
M;G-U<FEN9R!M;W)E('1H86X@;VYE(&9I96QD(&AA<R!B965N(&-O;7!L971E
M9"!I;B!C97)T86EN(&-A<V5S("AE9R!T:&5Y(&-A;B!O;FQY('-E87)C:"!U
M;F1E<B!E;6%I;"!B>2!I='-E;&8N("!/=&AE<B!S96%R8VAE<R!R97%U:7)E
M(&UO<F4@=&AA;B Q(&9I96QD('1O(&)E(&-O;7!L971E9"!I9B!E;6%I;"!I
M<R!O;6UI='1E9"D@86YD(&1I<W!L87EI;F<@<V5A<F-H(')E<W5L=',N#0H-
M"DD@:&%V92!P;W-T960@97AA;7!L97,@;V8@,B!P86=E<RX@(&1A=&%?96YT
M<GDN<&AP(&%N9"!R97-U;'1S+G!H<"!S;R!Y;W4@8V%N(&=E="!A;B!I9&5A
M+B @;7E486)L92!C;VYT86EN<R!S=7)N86UE+"!F:7)S=&YA;64@86YD(&5M
M86EL(&-O;'5M;G,@9F]R('1H:7,@97AC97)I<V4N#0H-"DD@86T@<F5A;&QY
M('-O<G)Y('1O('!O<W0@86QL('1H:7,@8G5T($D@86T@=&]T86QL>2!S='5C
M:RX@($D@:&%V92!B;W5G:'0@,R!B;V]K<R!O;B!02% O35E344P@86YD('9I
M<VET960@=F%R:6]U<R!S:71E<R!F;W(@<V%M<&QE(&-O9&4@*&%L;"!O9B!W
M:&EC:"!W;W)K(&1U<FEN9R!T97-T*2!B=70@9&\@;F]T('=O<FL@:6X@;7D@
M<VET92X@(%1H92!P<F]B;&5M(&UU<W0@8F4@=VET:"!M>2!C;V1I;F<N("!0
D3&5A<V4@:&5L<"!I9B!Y;W4@8V%N+@T*#0H-"@T*#0H-"C\^
`
end
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
