[swapna]

Hi All

I want to retrieve records from my local database,for that i am using mysql connection and query.but i am not able to get records.Below is my code:-
mysql_connect('localhost', 'root', '');
mysql_select_db("db_grant");
$sql = "SELECT id FROM accounts WHERE name = 'Tortoise Corp' ";
$result = mysql_query($sql);
if($row=mysql_fetch_array($result))
{
@@res=$row['id'];
}
I am using "@@res" variable in output document file.
Please help me...........
Thanks.

[amosbatto]

There really is no reason to use mysql_connect() if this code is in a trigger. Instead, you should use executeQuery() and the unique ID for a database connection.