acwe88

Hi thanks for your reply i appreciate it very muchCould you explain what these lines of code are doing as it is mesiing my page upAnd im not to sure what to do about itAlso how do i connect to my mysql database?ThanksAl

hi could somebody please convert this to php as im having real trouble sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="sql=sql & request.querystring("q")set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("/db/northwind.mdb"))set rs = Server.CreateObject("ADODB.recordset")rs.Open sql, connresponse.write("<table>")do until rs.EOFfor each x in rs.Fieldsresponse.write("<tr><td><b>" & x.name & "</b></td>")response.write("<td>" & x.value & "</td></tr>")nextrs.MoveNextloopresponse.write("</table>") Thanks in advanceAlex