There is an ADO simulator for PHP (i think it's called ADODB PHP but i can't remember the link). There is also a asp to php converter called (can you guess? ) asp2php.
Alistair Hayward wrote:
Hi ,
What is the equavilant in PHP to creating a recordset in ASP using a query?
This is what I do in PHP:
..................................
dim Type Type = CStr(Request.QueryString("action")) (getting parameter from URL)
Dim cnn ' ADO connection Dim rst ' ADO recordset Dim strDBPath ' path to my Access database (*.mdb) file
strDBPath = Server.MapPath("/_database/database.mdb")
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"
Set rst = cnn.Execute("SELECT * FROM table WHERE Type ='" & type & "' order by style")
..........................................
I can then call any field and display it in the html by using :
<%=rst.fields("whatever").value%>
..........................................
I can also create a loop:
<%Do While Not rstSimple.EOF%>
do something
<%
rstSimple.MoveNext
Loop
%>
............................................
Please can someone show me how to do the same thing in PHP?
Alistair
--
Raditha Dissanayake.
---------------------------------------------------------------
http://www.radinks.com/upload/ Drag and Drop Upload thousands of files and folders in a single
transfer. (HTTP or FTP)
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
