Notice: Use of undefined constant DBlink - assumed 'DBlink' in D:\Development\Completed\Sealhouse\phpSealTest\ProductSpecs.php on line 24
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\Development\Completed\Sealhouse\phpSealTest\ProductSpecs.php on line 24
Ligaya Turmelle wrote:
I don't know ASP but I think this is what you want:
$sql = "SELECT * FROM table WHERE Type = \"& type & \" order by style;";
$resultID = mysql_query($sql, DBlink); // send the query and returns a pointer to the results while ($row = mysql_fetch_assoc($resultID)) // while there are results give them to me as an associative array // results could also be returned as an array, object, or row // see mysql_fetch_array, mysql_fetch_object, and mysql_fetch_row respectively { Here is a loop }
"Alistair Hayward" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
