<?php 
	
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'ccdb';
mysql_select_db($dbname);
$sql="SELECT * FROM transactions"; 

$result = mysql_query($sql) or die(mysql_error());

if (!$conn)
{ 
exit("Error in SQL");

<?php 

# connect to a DSN "mydb"
$connect = odbc_connect("mydb", "", "");

# queries 
$sql="SELECT * FROM Transactions"; 

#perform the querries
$rs=odbc_exec($connect,