Hi all, which is the correct method to get a value from the database table into a php variable using the select statement for both oracle and mssql databases. for example if i have a query like "SELECT email_address FROM users_activation WHERE username='$username';". how to get the email address into a simple string variable from above select statement using oci8 functions and mssql functions. Thanks babu --------------------------------- How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! Photos