Heres the code im trying to run, there's more to it but i dont think you'll need to see it:
<?
include("dbFunctions.php3");
$dbcnx = myConnect();
$sql_count1 = "SELECT COUNT(PROD_ID) FROM $table_products WHERE CATAGORY = \"DVD\"";
$sql_count2 = "SELECT COUNT(PROD_ID) FROM $table_products WHERE CATAGORY = \"VHS\"";
$sql_count3 = "SELECT COUNT(PROD_ID) FROM $table_products WHERE CATAGORY = \"Books\"";
$sql_count4 = "SELECT COUNT(PROD_ID) FROM $table_products WHERE CATAGORY = \"Misc.\"";
$sql_info1 = "SELECT PROD_ID, PROD_NAME FROM $table_products WHERE CATAGORY = \"DVD\"";
$sql_info2 = "SELECT PROD_ID, PROD_NAME FROM $table_products WHERE CATAGORY = \"VHS\"";
$sql_info3 = "SELECT PROD_ID, PROD_NAME FROM $table_products WHERE CATAGORY = \"Books\"";
$sql_info4 = "SELECT PROD_ID, PROD_NAME FROM $table_products WHERE CATAGORY = \"Misc.\"";
$sql_result_count1 = mysql_query($sql_count1,$connection) or die ("Coudn't get count");
$sql_result_count2 = mysql_query($sql_count2,$connection) or die ("Coudn't get count");
$sql_result_count3 = mysql_query($sql_count3,$connection) or die ("Coudn't get count");
$sql_result_count4 = mysql_query($sql_count4,$connection) or die ("Coudn't get count");
$sql_result_info1 = mysql_query($sql_count1,$connection) or die ("Coudn't get records");
$sql_result_info2 = mysql_query($sql_count2,$connection) or die ("Coudn't get records");
$sql_result_info3 = mysql_query($sql_count3,$connection) or die ("Coudn't get records");
$sql_result_info4 = mysql_query($sql_count4,$connection) or die ("Coudn't get records");
$count1 = mysql_result($sql_result_count1,0,"count(PROD_ID)");
$count2 = mysql_result($sql_result_count2,0,"count(PROD_ID)");
$count3 = mysql_result($sql_result_count3,0,"count(PROD_ID)");
$count4 = mysql_result($sql_result_count4,0,"count(PROD_ID)");
?>
and here is the error i'm getting:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /spare/apache/htdocs/studdocs/c0053631/shop_viewbycat.php3 on line 15
Coudn't get count
