please help to convert this to php
index_search.asp--
<LINK REL="SHORTCUT ICON" HREF="http://www.dark-realm.org/listing/favicon.ico">
<%@LANGUAGE="VBSCRIPT"%>
<html>
<style type="text/css">
<!--
body {
background-image: url(Cracked%20Edition11.JPG);
}
.style1 {color: #00FF00}
.style2 {
font-size: x-large;
color: #00FF00;
}
-->
</style><head>
<title>Darkrealm Listing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#000000" text="#FFFFFF">
<div align="center">
<p><img src="LOGO_DARK.png" width="657" height="75"></p>
</div>
<FORM Mothod=post Action="results.asp">
<span class="style1">Search for:</span>
<INPUT TYPE=TEXT NAME="search" SIZE=12>
<span class="style1">in</span>
<SELECT NAME=category>
<OPTION VALUE="games">Games
<OPTION VALUE="apps">Apps
<OPTION VALUE="vcd">Vcd
<OPTION VALUE="divx">Divx
<OPTION VALUE="dvd">DVD
<OPTION VALUE="dvdxxx">XXX DVD
<OPTION VALUE="xxx">XXX
<OPTION VALUE="anime">Anime
<OPTION VALUE="animexxx">XXX Anime
<OPTION VALUE="cartoons">Cartoons
<OPTION VALUE="tvseries">Tv Series
<OPTION VALUE="mp3">MP3
<OPTION VALUE="musicvideos">Music Videos
</SELECT>
<INPUT TYPE=SUBMIT VALUE="Search Darkrealm">
</FORM>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </
<p> </p>
</body>
</html>
results.asp---
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Darkrealm Listing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
color: #00FF00;
font-size: x-large;
}
.style2 {
color: #00FF00;
font-size: medium;
}
-->
</style>
</head>
<body bgcolor="#000000" text="#FFFFFF">
<div align="center">
<p class="style1"><img src="LOGO_DARK.png" width="657" height="75"></p>
<p class="style2">Search Darkrealms Software Library</p>
<p> </p>
<%
Dim objConn
Dim sqlString
Dim objRS
Dim strtable, strsearch
strtable = request("category")
strsearch = request("search")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "darkrealm"
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
sqlString = "Select * FROM "&strtable&" WHERE Name LIKE '%" &strsearch& "%'"
objRS.Open sqlString, objConn
%>
<TABLE border=2>
<TR><TD><B>Name:</B></TD>
<TD><B>DiscID:</B></TD>
<TD><B>CDs:</B></TD>
<TD><B>Comments:</B></TD>
</TR>
<%
Do Until objRS.EOF = True
Response.Write "<TR><TD>" & objRS("Name")
Response.Write "<TD>" & objRS("DiscID")
Response.Write "<TD>" & objRS("CDs")
Response.Write "<TD>" & objRS("Comments")
objRS.MoveNext
Loop
%>
</TABLE>
</div>
<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
</body>
</html>
please help me to convert this
and this connects to ms sql server its all in the results.asp that i need it to be converted to php
