jarv Posted April 18, 2007 Share Posted April 18, 2007 hi I would like to connect to a database to retrieve some records could someone please check my code... <?php $var = Connection; $var = sConnString; $sSQL Set Connection = Server.CreateObject("ADODB.Connection") sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("db/tellist.mdb") Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnection sSQL = "SELECT * FROM phonebook"; Set rsContactList = objconn.execute("PhoneBook") Do While Not rsContactlist.EOF echo rsContactlist("rsName") rsContactlist.MoveNext Loop objConn.close Set rsContactlist = Nothing ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.