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([EMAIL PROTECTED]),:6YK(#T@;7ES6Q?8V]N;F5C=@B;]C86QH
M;W-T(BP@(FAT='!D(BP@(B(I*2D-B @PT*( @('!R:6YT*)86EL960@
M=[EMAIL PROTECTED];F5C=!T;R!D871A8F%S92$\8G(^7XB*3L-B @(!PFEN=@B
M06)OG1I;FA/)R/EQN(BD[#0H@( @97AI=@I.PT*(!]#0H@( T*(!I
[EMAIL PROTECTED]1D8E)EW5L= ](UYW%L7W%U97)Y*)54T4@V5A8V%D971S(BP@
M)1B3EN:RDI*0T*(![#0H@( @')I;G0H(E5N86)L92!T;R!UV4@V5A
M8V%D971S(1A=%B87-E(3QBCY;B(I.PT*( @('!R:6YT*)!8F]R=EN
M9R$\8G(^7XB*3L-B @(!EET*D[#0H@('T-B @#0H@(11=65R2 ]
M()314Q%0U0@(B N#0H@( @(F-A95T+G)A;FLL(-A95T+FQN86UE+!C
M861E=YF;[EMAIL PROTECTED];6YA;64L((@[EMAIL PROTECTED]( @()C861E=YA91R
M97-S,[EMAIL PROTECTED]F5SS(L(-A95T+F-I='DL(-A95T+G-T871E
M+!C861E=YZ:7!C;V1E+!C861E=YE;6%I;P@(B N#0H@( @(F-A95T
M+F=U87)D:6%N,[EMAIL PROTECTED]F5L871I;VXQ+!C861E=YG=6%R9EA;C(L
M(-A95T+G)E86QT:6]N,[EMAIL PROTECTED]AO=\L((@[EMAIL PROTECTED]( @()4D]-
M(-A95T+!C861E=%]P:]N92 B(X-B @( B5TA%4D4@(B N#0H@( @
M(F-A95T+G-S;B ](-A95T7W!H;VYE+G-S;B B(X-B @( B04Y$(AC
M861E=YL;F%M92 ](%PB4VUI=A([EMAIL PROTECTED];64@/2!(DIO
M:Y([EMAIL PROTECTED];6YA;64@/2!(D1O95PB*2 B.PT*#0H@(EF*$H
M)1B4F5S=6QT(#T@;7ES6Q?75EGDH)%%U97)Y+ D9),:6YK*2DI#0H@
M('L-B @(!PFEN=@B0V]U;1N)[EMAIL PROTECTED]2$\8G(^7XB
M*3L-B @(!PFEN=@B37E344P@F5P;W)TSH@(B N(UYW%L7V5RF]R
M*[EMAIL PROTECTED] B/)R/EQN(BD[#0H@( @')I;G0H(E%U97)Y('=ASH@)%%U97)Y
M/)R/EQN(BD[#0H@( @97AI=@I.PT*([EMAIL PROTECTED]@('!R:6YT*(\=%B
M;[EMAIL PROTECTED]5R/5PB,%PB/EQN(BD[#0H@( T*(!PFEN=@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*(\=[EMAIL PROTECTED];VQOCU(B-C8V-C
M8V-(CX\8CY,87-T($YA;64\+V(^/]T9#Y;B(I.PT*( @('!R:6YT*(\
M=[EMAIL PROTECTED];VQOCU(B-C8V-C8V-(CX\8CY:7)S=!.86UE/]B/CPO=0^
M7XB*3L-B @(!PFEN=@B/'1D()G8V]L;W(]7(C8V-C8V-C7(^/(^
M36ED9QE($YA;64\+V(^/]T9#Y;B(I.PT*( @('!R:6YT*(\=[EMAIL PROTECTED]
M;VQOCU(B-C8V-C8V-(B!C;VQS%N/5PB,EPB/CQB/E-TF5E=!!91R
M97-S/]B/CPO=0^7XB*3L-B @(!PFEN=@B/'1D()G8V]L;W(]7(C
M8V-C8V-C7(^/(^0VET3PO8CX\+W1D/EQN(BD[#0H@( @')I;G0H(CQT
M9!B9V-O;]R/5PB(V-C8V-C8UPB/CQB/E-T871E/]B/CPO=0^7XB*3L-
MB @(!PFEN=@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^7XB*3L-B @(!PFEN=@B/'1D
M()G8V]L;W(]7(C8V-C8V-C7(^/(^1W5AF1I86X@,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^7XB*3L-B @(!PFEN=@B/'1D()G8V]L;W(]
M7(C8V-C8V-C7(^/(^1W5AF1I86X@,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^7XB*3L-B @(!PFEN=@B/'1D()G8V]L;W(]7(C8V-C8V-C
M7(^/(^4AO=\\+V(^/]T9#Y;B(I.PT*( @('!R:6YT*(\=[EMAIL PROTECTED]
M;VQOCU(B-C8V-C8V-(CX\8CY0:]N92!.=6UB97(\+V(^/]T9#Y;B(I
M.PT*( @('!R:6YT*(\=[EMAIL PROTECTED];VQOCU(B-C8V-C8V-(CX\8CY47!E
M/]B/CPO=0^7XB*3L-B @(!PFEN=@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:[EMAIL PROTECTED])2;W@/2!M7-Q;%]F971C:%]AW-O
[EMAIL PROTECTED])297-U;'0I*0T*(![#0H@( @')I;G0H(CQTCY;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^7XB*3L-B @
M( @('!R:6YT*(\=0^R1D8E)O=ULG9FYA;64G77T\+W1D/EQN(BD[#0H@
M( @(!PFEN=@B/'1D/GLD9)2;W=;)VUN86UE)UU]/]T9#Y;B(I.PT*
M( @( @')I;G0H(CQT9#Y[)1B4F]W6R=A91R97-S,2==?3PO=0^7XB
M*3L-B @( @('!R:6YT*(\=0^R1D8E)O=ULG861DF5SS(G77T\+W1D
M/EQN(BD[#0H@( @(!PFEN=@B/'1D/GLD9)2;W=;)V-I='DG77T\+W1D
M/EQN(BD[#0H@( @(!PFEN=@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^7XB*3L-B @( @('!R:6YT*(\=0^R1D8E)O=ULG9W5AF1I
M86XQ)UU]/]T9#Y;B(I.PT*( @( @')I;G0H(CQT9#Y[)1B4F]W6R=R
M96QA=EO;C$G77T\+W1D/EQN(BD[#0H@( @(!PFEN=@B/'1D/GLD9)2
M;W=;)V=U87)D:6%N,B==?3PO=0^7XB*3L-B @( @('!R:6YT*(\=0^
MR1D8E)O=ULGF5L871I;VXR)UU]/]T9#Y;B(I.PT*( @( @')I;G0H
M(CQT9#Y[)1B4F]W6R=P:]T;R==?3PO=0^7XB*3L-B @( @('!R:6YT
M*(\=0^R1D8E)O=ULGAO;F5?;G5M)UU]/]T9#Y;B(I.PT*( @( @
M')I;G0H(CQT9#Y[)1B4F]W6R=T7!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*(!PFEN=@B/]T86)L93Y
(;B(I.PT*/SX`
`
end
--
PHP Database Mailing
