asked on 7/23/2008

PHP translation to Classic ASP

Please translate the PHP code to Classic ASP. I do not know PHP at all and I am trying to get an AJAX fuction to work in ASP. The translation will help me do that. Thanks for your help!

<?php 
if(empty($_GET['topic'])) {   
	exit(); 
} 
$topic = $_GET['topic']; 
$link = mysql_connect("localhost","username","password"); 
mysql_select_db("database_name"); 
 
 
$query = "SELECT item FROM info WHERE cat = '".mysql_real_escape_string($topic)."'";  
$result = mysql_query($query); 
 
if($result) { 
	$items = array(); 
 
	while($row = mysql_fetch_array($result)) {       
		$items[] = $row['item']; 
	} 
 
$string = implode(',',$items); 
echo $string; 
} 
?>

Last Comment

7/24/2008

7/23/2008

if len(request("topic")) > 0 then

set objConn = CreateObject("Adodb.Connection")
objConn.Open strYourConnectionStringHere
set objRS = objConn.Execute("SELECT item FROM info WHERE cat = '" & replace(request("topic"),"'","")) & "'")
if not(objRS.EOF) then
do while not(objRS.EOF)
response.write(objRS("item"))
objRS.MoveNext
loop
else
response.write("No Records Found")
end if
set objRS = nothing
objConn.Close
set objConn = Nothing

ASKER CERTIFIED SOLUTION

kevp75

7/23/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ritschel

7/24/2008

ASKER

Thanks for your quick response!

kevp75

7/24/2008

thatnks for the grade....glad I could help :)