Just can't seem to get past this error "Warning: mysql_result(): supplied argument is not a valid MySQL result resource" which is generated by the last of the follow script segment. Any thoughts would be most appreciated.
Cheers,
Steve
/*****************************
DB Variables
**************************/
$server = '';
$dbname = '';
$dbuser = '';
$dbpass = '';
/**************************
DB Connection
**************************/
if ( !@mysql_connect( $server, $dbuser, $dbpass ) ) {
echo( 'Could not establish a connection to the database' );
exit;
}
/**************************
Select DB
**************************/
if ( !@mysql_select_db( $dbname ) ) {
echo( 'Could not establish a connection to the database' );
exit;
}
/**************************
DB Query
****************************/
$qry1 = mysql_query("SELECT FROM pycontact, pycategory WHERE ((pycontact.customerid = pycategory.fkcustomerid) AND (pycontact.city = '$city')) ORDER BY pycategory.category DESC LIMIT $count");
$nre = mysql_result($qry1,0);
