asp connection with mysql

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi,

i'm a total noob in asp, and i only need a couple of lines for them. The only thing i 'm looking for is the script to connect with a db and query it.
Is there someone who can translate this script form php to asp? it would help me a lot. thx

@ $db = mysql_pconnect('localhost', 'username' , 'password');
if (!$db)
{
echo 'Error: Can not connect.';
exit;
}
mysql_select_db('dbname');

$query = 'select * from table '
."where id='$id' ";
$result = mysql_query($query);

$row = mysql_fetch_array($result);
echo'The ID is: '.$row[id].'';