<?php

$dbhost="127.0.0.1";
$dbuser="tixuser";
$dbpass="txr0user";
$dbname="tix";

$sql = "select * from tickets";

$con = mysql_connect($dbhost,$dbuser,$dbpass) or die ("couldnt connect " . mysql_error());

if (!$con) { die ("couldnt connect " . mysql_error()); }

@mysql_select_db($dbname) or die ("unable to select table " . mysql_error());

$result = mysql_query($sql) or die ("query failed " . msyql_error());

while($row = mysql_fetch_array($result)){
        echo $row['cust_name']. " - ". $row['cust_ticket_number'];
}

mysql_close($con);

?>