I have a query that works in MySQL but when I try to execute it in PHP I
encounter the following error:
//Generated by the script
Couldn't execute query!
// Generated by MySQL
MySQL reports: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'FROM cadet, cadet_phone WHERE cadet.ssn = cadet_phone.ssn AND (
//Query outputted by the script
Query was: SELECT cadet.rank, cadet.lname, cadet.fname, cadet.mname,
cadet.address1, cadet.address2, cadet.city, cadet.state, cadet.zipcode,
cadet.email, cadet.guardian1, cadet.relation1, cadet.guardian2,
cadet.realtion2, cadet.photo, FROM cadet, cadet_phone WHERE cadet.ssn =
cadet_phone.ssn AND (cadet.lname = "Smith" AND cadet.fname = "John" AND
cadet.mname = "Doe")
Attached is the entire page. Any help is appreciated.
Sean Smitz
begin 666 test0.1.php
M/#]P:' -"B @:68H(2@D9&),:6YK(#T@;7ES<6Q?8V]N;F5C="@B;&]C86QH
M;W-T(BP@(FAT='!D(BP@(B(I*2D-"B @>PT*(" @('!R:6YT*")&86EL960@
M=&\@8V]N;F5C="!T;R!D871A8F%S92$\8G(^7&XB*3L-"B @("!P<FEN="@B
M06)O<G1I;F<A/&)R/EQN(BD[#0H@(" @97AI="@I.PT*("!]#0H@( T*("!I
M9B@A*"1D8E)E<W5L=" ](&UY<W%L7W%U97)Y*")54T4@<V5A8V%D971S(BP@
M)&1B3&EN:RDI*0T*("![#0H@(" @<')I;G0H(E5N86)L92!T;R!U<V4@<V5A
M8V%D971S(&1A=&%B87-E(3QB<CY<;B(I.PT*(" @('!R:6YT*")!8F]R=&EN
M9R$\8G(^7&XB*3L-"B @("!E>&ET*"D[#0H@('T-"B @#0H@("11=65R>2 ]
M(")314Q%0U0@(B N#0H@(" @(F-A9&5T+G)A;FLL(&-A9&5T+FQN86UE+"!C
M861E="YF;F%M92P@8V%D970N;6YA;64L("(@+@T*(" @(")C861E="YA9&1R
M97-S,2P@8V%D970N861D<F5S<S(L(&-A9&5T+F-I='DL(&-A9&5T+G-T871E
M+"!C861E="YZ:7!C;V1E+"!C861E="YE;6%I;"P@(B N#0H@(" @(F-A9&5T
M+F=U87)D:6%N,2P@8V%D970N<F5L871I;VXQ+"!C861E="YG=6%R9&EA;C(L
M(&-A9&5T+G)E86QT:6]N,BP@8V%D970N<&AO=&\L("(@+@T*(" @(")&4D]-
M(&-A9&5T+"!C861E=%]P:&]N92 B("X-"B @(" B5TA%4D4@(B N#0H@(" @
M(F-A9&5T+G-S;B ](&-A9&5T7W!H;VYE+G-S;B B("X-"B @(" B04Y$("AC
M861E="YL;F%M92 ](%PB4VUI=&A<(B!!3D0@8V%D970N9FYA;64@/2!<(DIO
M:&Y<(B!!3D0@8V%D970N;6YA;64@/2!<(D1O95PB*2 B.PT*#0H@(&EF*"$H
M)&1B4F5S=6QT(#T@;7ES<6Q?<75E<GDH)%%U97)Y+" D9&),:6YK*2DI#0H@
M('L-"B @("!P<FEN="@B0V]U;&1N)W0@97AE8W5T92!Q=65R>2$\8G(^7&XB
M*3L-"B @("!P<FEN="@B37E344P@<F5P;W)T<SH@(B N(&UY<W%L7V5R<F]R
M*"D@+B B/&)R/EQN(BD[#0H@(" @<')I;G0H(E%U97)Y('=A<SH@)%%U97)Y
M/&)R/EQN(BD[#0H@(" @97AI="@I.PT*("!]#0H@#0H@('!R:6YT*"(\=&%B
M;&4@8F]R9&5R/5PB,%PB/EQN(BD[#0H@( T*("!P<FEN="@B/'1R/EQN(BD[
M#0H@(" @<')I;G0H(CQT9"!B9V-O;&]R/5PB(V-C8V-C8UPB/CQB/E)A;FL\
M+V(^/"]T9#Y<;B(I.PT*(" @('!R:6YT*"(\=&0@8F=C;VQO<CU<(B-C8V-C
M8V-<(CX\8CY,87-T($YA;64\+V(^/"]T9#Y<;B(I.PT*(" @('!R:6YT*"(\
M=&0@8F=C;VQO<CU<(B-C8V-C8V-<(CX\8CY&:7)S="!.86UE/"]B/CPO=&0^
M7&XB*3L-"B @("!P<FEN="@B/'1D(&)G8V]L;W(]7"(C8V-C8V-C7"(^/&(^
M36ED9&QE($YA;64\+V(^/"]T9#Y<;B(I.PT*(" @('!R:6YT*"(\=&0@8F=C
M;VQO<CU<(B-C8V-C8V-<(B!C;VQS<&%N/5PB,EPB/CQB/E-T<F5E="!!9&1R
M97-S/"]B/CPO=&0^7&XB*3L-"B @("!P<FEN="@B/'1D(&)G8V]L;W(]7"(C
M8V-C8V-C7"(^/&(^0VET>3PO8CX\+W1D/EQN(BD[#0H@(" @<')I;G0H(CQT
M9"!B9V-O;&]R/5PB(V-C8V-C8UPB/CQB/E-T871E/"]B/CPO=&0^7&XB*3L-
M"B @("!P<FEN="@B/'1D(&)G8V]L;W(]7"(C8V-C8V-C7"(^/&(^6FEP8V]D
M93PO8CX\+W1D/EQN(BD[#0H@(" @<')I;G0H(CQT9"!B9V-O;&]R/5PB(V-C
M8V-C8UPB/CQB/D5M86EL/"]B/CPO=&0^7&XB*3L-"B @("!P<FEN="@B/'1D
M(&)G8V]L;W(]7"(C8V-C8V-C7"(^/&(^1W5A<F1I86X@,3PO8CX\+W1D/EQN
M(BD[#0H@(" @<')I;G0H(CQT9"!B9V-O;&]R/5PB(V-C8V-C8UPB/CQB/E)E
M;&%T:6]N/"]B/CPO=&0^7&XB*3L-"B @("!P<FEN="@B/'1D(&)G8V]L;W(]
M7"(C8V-C8V-C7"(^/&(^1W5A<F1I86X@,CPO8CX\+W1D/EQN(BD[#0H@(" @
M<')I;G0H(CQT9"!B9V-O;&]R/5PB(V-C8V-C8UPB/CQB/E)E;&%T:6]N/"]B
M/CPO=&0^7&XB*3L-"B @("!P<FEN="@B/'1D(&)G8V]L;W(]7"(C8V-C8V-C
M7"(^/&(^4&AO=&\\+V(^/"]T9#Y<;B(I.PT*(" @('!R:6YT*"(\=&0@8F=C
M;VQO<CU<(B-C8V-C8V-<(CX\8CY0:&]N92!.=6UB97(\+V(^/"]T9#Y<;B(I
M.PT*(" @('!R:6YT*"(\=&0@8F=C;VQO<CU<(B-C8V-C8V-<(CX\8CY4>7!E
M/"]B/CPO=&0^7&XB*3L-"B @("!P<FEN="@B/'1D(&)G8V]L;W(]7"(C8V-C
M8V-C7"(^/&(^0V]N=&%C=#PO8CX\+W1D/EQN(BD[#0H@('!R:6YT*"(\+W1R
M/EQN(BD[#0H@( T*("!W:&EL92@D9&)2;W<@/2!M>7-Q;%]F971C:%]A<W-O
M8R@D9&)297-U;'0I*0T*("![#0H@(" @<')I;G0H(CQT<CY<;B(I.PT*(" @
M(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=R86YK)UU]/"]T9#Y<;B(I.PT*(" @
M(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=L;F%M92==?3PO=&0^7&XB*3L-"B @
M(" @('!R:6YT*"(\=&0^>R1D8E)O=ULG9FYA;64G77T\+W1D/EQN(BD[#0H@
M(" @("!P<FEN="@B/'1D/GLD9&)2;W=;)VUN86UE)UU]/"]T9#Y<;B(I.PT*
M(" @(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=A9&1R97-S,2==?3PO=&0^7&XB
M*3L-"B @(" @('!R:6YT*"(\=&0^>R1D8E)O=ULG861D<F5S<S(G77T\+W1D
M/EQN(BD[#0H@(" @("!P<FEN="@B/'1D/GLD9&)2;W=;)V-I='DG77T\+W1D
M/EQN(BD[#0H@(" @("!P<FEN="@B/'1D/GLD9&)2;W=;)W-T871E)UU]/"]T
M9#Y<;B(I.PT*(" @(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=Z:7!C;V1E)UU]
M/"]T9#Y<;B(I.PT*(" @(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=E;6%I;"==
M?3PO=&0^7&XB*3L-"B @(" @('!R:6YT*"(\=&0^>R1D8E)O=ULG9W5A<F1I
M86XQ)UU]/"]T9#Y<;B(I.PT*(" @(" @<')I;G0H(CQT9#Y[)&1B4F]W6R=R
M96QA=&EO;C$G77T\+W1D/EQN(BD[#0H@(" @("!P<FEN="@B/'1D/GLD9&)2
M;W=;)V=U87)D:6%N,B==?3PO=&0^7&XB*3L-"B @(" @('!R:6YT*"(\=&0^
M>R1D8E)O=ULG<F5L871I;VXR)UU]/"]T9#Y<;B(I.PT*(" @(" @<')I;G0H
M(CQT9#Y[)&1B4F]W6R=P:&]T;R==?3PO=&0^7&XB*3L-"B @(" @('!R:6YT
M*"(\=&0^>R1D8E)O=ULG<&AO;F5?;G5M)UU]/"]T9#Y<;B(I.PT*(" @(" @
M<')I;G0H(CQT9#Y[)&1B4F]W6R=T>7!E)UU]/"]T9#Y<;B(I.PT*(" @(" @
M<')I;G0H(CQT9#Y[)&1B4F]W6R=C;VYT86-T)UU]/"]T9#Y<;B(I.PT*(" @
M('!R:6YT*"(\+W1R/EQN(BD[#0H@('T-"@T*("!P<FEN="@B/"]T86)L93Y<
(;B(I.PT*/SX`
`
end
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
