I know all of ZERO ASP but think I infer what you are trying to do from that
code snippet. What you want is:
#Do not need an ODBC conenction first off
$connect=mysql_pconnect('localhost', 'user', 'password');
mysql_select_db('database', $connect);
# Do the SQL query
$resource=mysql_query('SELECT * FROM categories');
# Step through each row returned
while($row=mysql_fetch_array($queryexe)){
extract($row);
echo "$categoryid, $catdescription, $catimage<br/>";
}
Hope this helps,
-Peter
##################################
Peter Thoenen - Systems Programmer
Commercial Communications
Camp Bondsteel, Kosovo
##################################
> -----Original Message-----
> From: David R [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 14, 2002 12:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Code Conversion ASP --> PHP Example
>
>
> I am in the early stages of learning PHP as an alternative to
> ASP. I am
> using MySQL and need a beginning nudge. If anyone has the
> time, could you
> please convert the following basic code block into pure
> PHP/MySQL minus all
> the MS bits? It's a very simple example I know but the
> principles would
> help me to understand some things that are not sinking in
> right now. Thank
> you!
>
> <%
>
> strConnection = "driver={MySQL ODBC 3.51
> Driver};server=localhost;user=username;"
> strConnection = strConnection & "pwd=demo;database=mysql450"
>
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open strConnection
>
> strSQL = "SELECT * FROM categories"
>
> Set objRS = objConn.Execute(strSQL)
>
> Do While Not objRS.EOF
> Response.Write objRS("categoryid") & ", "
> Response.Write objRS("catdescription") & ", "
> Response.Write objRS("catimage") & "<br>"
> objRS.MoveNext
> Loop
>
> objRS.Close
> Set objRS = Nothing
> objConn.Close
> Set objConn = Nothing
>
> %>
>
> David
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
begin 600 winmail.dat
M>)\^(CD7`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`06``P`.````T@<(``X`
M`P`)``0``P`"`0$@@`,`#@```-('"``.``$`.``W``,`8@$!"8`!`"$````R
M-D0Y.#`X-41$.#<X0S0U.49&,44Q,CE!0T%#-C!#,0!.!P$$@`$`,@```%)%
M.B!;4$A0+5=)3ET@0V]D92!#;VYV97)S:6]N($%34"`M+3X@4$A0($5X86UP
M;&4`/0\!#8`$``(````"``(``0.0!@",#0``,P````,`"5D!`````@$Q``$`
M``!$`0``4$-$1D5",#D``0`"`($`````````.*&[$`7E$!JANP@`*RI6P@``
M14U3341"+D1,3```````````&U7Z(*IF$<V;R`"J`"_$6@P```!"3TY$4U1%
M14PR`"]O/4]21T%.25I!5$E/3B]O=3U41D8@0D].1%-4145,+V-N/5)E8VEP
M:65N=',O8VX]5&AE;VYE4``N`````````$/#%Z&QP/I%N#_P?AL13-@!`*<S
M_YL?L/1!LZ8@G_<0,.4```$&"3L````````N`````````$/#%Z&QP/I%N#_P
M?AL13-@!`*<S_YL?L/1!LZ8@G_<0,.4```$&49P``!`````FV8"%W8>,19_Q
MX2FLK&#!,@```%)%.B!;4$A0+5=)3ET@0V]D92!#;VYV97)S:6]N($%34"`M
M+3X@4$A0($5X86UP;&4``P#>/Z]O```#``"`""`&``````#`````````1@``
M``!2A0``)VH!`!X``8`((`8``````,````````!&`````%2%```!````!```
M`#DN,``+``N`""`&``````#`````````1@`````&A0````````,``H`((`8`
M`````,````````!&``````&%````````"P`#@`@@!@``````P````````$8`
M`````X4````````+``2`""`&``````#`````````1@`````.A0````````,`
M!8`((`8``````,````````!&`````!"%`````````P`&@`@@!@``````P```
M`````$8`````$84````````#``>`""`&``````#`````````1@`````8A0``
M`````!X`"(`((`8``````,````````!&`````#:%```!`````0`````````>
M``F`""`&``````#`````````1@`````WA0```0````$`````````'@`*@`@@
M!@``````P````````$8`````.(4```$````!``````````(!"1`!````+P8`
M`"L&``"?"@``3%I&=<MYYJX#``H`<F-P9S$R->(R`T-T97@%00$#`??_"H`"
MI`/D!Q,"@`_S`%`$5C\(50>R$24.40,!`@!C:.$*P'-E=#(&``;#$27V,P1&
M$[<P$BP1,PCO"?>V.Q@?#C`U$2(,8&,`4#,+"0%D,S864`NF($EP(&MN;P?@
M!T`#(&]`9B!:15)/$,!3D%`@8G4%0'1H"X#6:QSA"X!F$H%W$^`%0)YY"&`=
M4!@@'I!R>0N`XF<>D&\@9"#0`U(>D2<?H06@`0`@<P,`<'"A%"`N("!7'Y9W
M`'`[!4`$`#H*H@J$"H`C1-<@T!T@!4!N">!D'5`#H#!/1$)#(;$E`&YC['1I
M`B`A$&D4``5`':`Z9B/*)"71)0`F(#UM0'ES<6Q?<"?E*$HG%[!C!T!H;R:P
M)]`L("=U%!!R*?(*L,4$$'<%L&0G*1DP(].+*&04$&PH(5]D8BE`[F0?H`&@
M*L!E*?$GUBM&'20E("21'J`@,%-13+P@<0I0(&`G&Q@@<PAA'&-E*%4OLRE`
M4T5,@$5#5"`J($8=\&9-(;`?H&5G!;`(D'-K*S<NAE,.L'`>D0-@=?!G:"!E
M`-`U<`-@!^#]&"!T"'`E``LQ(^@?@`,0O&4H,,`=,"A5'T!T$]#27PK`<F$R
M`"0OLP[`\&4I*5P``"/3(I`.P7\X\"DA-\(K1CIA$]`@T"+W)]`S)"!P9"UB
M'Z`!``3T!R9!//0'<&%G93QB4'(O/B(N%GTCRD@>;R)0'I($("]`;'!S\BPC
MRBU0%"`$D"/+0T_G1%XCQ$(S(%0IL`GP"?!,("T442:P96T$(%#S`V`)P&%M
M!X!"=0A01Z+N8P<Q$B%'H'4#`#XR`B"N<T?E1Y`T\$("(&1&X8LL,"H`2RG`
M;W9O0N^W3)]%"B/$/D:03O)/!1#69PN`2,%-!Y!S/H%.\Y5.=D8#83HN\&%V
M/-`Y!_`@6P#``Q`@P#HS0'AZ>2UI,R8@0"9S"K`'@'@N!:!M76].=@9@`C!1
M4%<)@"4`<W4LT'DJ`$$U4"HP!4`Q=C0J``'0,!1`#B!28#85$,!-3G944E`@
M<&@<<"T#\$J@'3!S0&Q1!`!T<RY7D2XE`'0Q4\=U8FHH(5%06U"`2%`M5TE.
M71(A\R'A"%!N=@20`)`F41XBQT[P3M!:02!%>$I!+$!_3G9=#ASP1Y`?$2\C
M-9!R_&QY(@`!D#Z0!"`=H2Q`_PK``P`@D5Q2*L`E0@=`0E'_3Y`F,%M0(+).
M=AXA(H%>@N=.=BHP(()->2]R`'`E,!\E!!Y0,T`+@&"#;G5D_SZ08Q(=L`!P
M']`E`$#P81$W+S).=CY192H`!:!U;/\E,!_13G9<T2TA)<);41Z"_R`P`A`=
M<!TP(((M$0W@(;3?`F`I<![@"X`@P7`(<&>8]5I!+V1D;0N`*C`=4F>WTR]!
M!>%B:5B`/V,A*>#]82$@6U%?@0=P7-$Z<5RS]QSF'F1GF'`%$"80!2`L0/\$
M("KP:+%.=D$";C!B$TDPOP2!7Z%DT3#P=2(>L6=G4N\?H2`2),)D$6L@@E[1
M3G9]3U%H).$=,"*!1B``<&O+3G8?T2%=#CPE70XFL*YR6R$H$B9"/3P@9`40
M'5M1/3G@9&0E@S,N-=L:\TZR1'X#/X`[*D%^(G4I9SLJ,CTJ,D^0!X`[+B)\
M;WUU?.PF/"!P=VQD/0$`!&`[+-8H5#3\-3""=TYV!E$FP5G`?1)G?;$&85M1
M+D,8(#,A3^%9PR@B040E@8D0?2?.(CG0AU:(!BY/(E`#H/]\ZX;/?.$O<GW!
M,C\S18:__8>W4@7P?<"+QER0!9`></\WH(YTBQ>'1R21(K`W@0>PIR31D@.2
M\$]&BRA2!Y#V<$FA9E!7!1`.L)'TB>#_/%B+`(32*@""=Y;OE_@]6?^9#YH?
ME_@^8YQT/K$^\(LK=98!34M@90?`#M"'1TSN;T!PD_^5U$,7L!00AT[_DC.5
MD7:2HPJ+\Z/_B`FEG?E.=B4^70Y1<UT/K$^M7'].\&T:(J!7Y`704A$@@DP)
M6&$@*'D@='`Z+^PO=[%P6*8OBQ=74'5Q_G-9L`3R97`J`%&0`)!4<5^Q#[(0
MLO-8HJT\?;;@`!X`<``!````+@```%M02%`M5TE.72!#;V1E($-O;G9E<G-I
M;VX@05-0("TM/B!02%`@17AA;7!L90````(!<0`!````&P````'"0RDL7X"]
M14EF;D6:I_7+15KE$7$``3L+$``#`"X```````L``@`!````'@!"$`$````J
M````/#(P,#(P.#$S,C(S-34Q+C8T-C8P+G%M86EL0'!B,2YP86ER+F-O;3X`
M```#`/T_Y`0``$``.0#0H]$N+T/"`0,`\3\)!```'@`Q0`$````(````5$A%
M3TY%4``#`!I``````!X`,$`!````"````%1(14].15```P`90``````#`"8`
M``````,`-@```````P"`$/____\"`4<``0```#D```!C/553.V$](#MP/4]2
M1T%.25I!5$E/3CML/4)/3D135$5%3#(M,#(P.#$T,#$P.3`T6BTT-3DS,0``
M```"`?D_`0```%8`````````W*=`R,!"$!JTN0@`*R_A@@$`````````+T\]
M3U)'04Y)6D%424].+T]5/51&1B!"3TY$4U1%14PO0TX]4D5#25!)14Y44R]#
M3CU42$5/3D50````'@#X/P$````8````4&5T97(@5&AO96YE;B`@37(N("!%
M4%,`'@`X0`$````(````5$A%3TY%4``"`?L_`0```%8`````````W*=`R,!"
M$!JTN0@`*R_A@@$`````````+T\]3U)'04Y)6D%424].+T]5/51&1B!"3TY$
M4U1%14PO0TX]4D5#25!)14Y44R]#3CU42$5/3D50````'@#Z/P$````8````
M4&5T97(@5&AO96YE;B`@37(N("!%4%,`'@`Y0`$````(````5$A%3TY%4`!`
M``<PE*W1+B]#P@%```@P#`19&B5#P@$>`#T``0````4```!213H@`````!X`
M'0X!````+@```%M02%`M5TE.72!#;V1E($-O;G9E<G-I;VX@05-0("TM/B!0
M2%`@17AA;7!L90```!X`-1`!````10```#Q!-S,S1D8Y0C%&0C!&-#0Q0C-!
M-C(P.49&-S$P,S!%-3`Q,#8U.#0V0&)O;F1S=&5E;#(N87)E=7(N87)M>2YM
M:6P^``````L`*0`!````"P`C``$````#``80)ZTPYP,`!Q`C!@```P`0$```
M```#`!$0`0```!X`"!`!````90```$E+3D]704Q,3T9:15)/05-00E545$A)
M3DM)24Y&15)72$%464]505)%5%)924Y'5$]$3T923TU42$%40T]$15-.25!0
M15172$%464]55T%.5$E3.B-$3TY/5$Y%141!3D]$0D,``````@%_``$```!%
M````/$$W,S-&1CE",49",$8T-#%",T$V,C`Y1D8W,3`S,$4U,#$P-C4X-#9`
@8F]N9'-T965L,BYA<F5U<BYA<FUY+FUI;#X`````8I,=
`
end
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
