I need help with mysql queries. I have these queries and they all work in the mysql command line but when I put then in my php code only one works. I get a blank page unless I comment out all of the queries execpt the first one. All of these did work correctly on the page at one time, and to my knowledge nothing has changed in the page or the database. I am new at php and am completely lost. Any help including how to make the queries more effiecent would be of great help.
<?php
*/
require_once("../ipplanlib.php");
require_once("../adodb/adodb.inc.php");
require_once("../layout/class.layout");
require_once("../auth.php");
//Authenication
if (!ANONYMOUS) {
$auth = new SQLAuthenticator(REALM, REALMERROR);
$auth -> authenticate();
}
setcookie("ipplanCustomer","$cust",time() + 10000000, "/");
//Language selection
isset($COOKIE["ipplanNoAuth"]) && myLanguage($COOKIE['ipplanLanguage']);
$title=my_("Inventory Report");
newhtml($p);
insert($p,block("<script type=\"text/javascript\">
</script>
<noscript>
<font size=4 color=\"#FF0000\">
<p><b>
Your browser must be JavaScript capable to use this application. Please turn JavaScript on.
</b>
</font>
</noscript>
"));
$w=myheading($p, $title, "../index.php", true);
insert($w, $f1 = form(array("name"=>"THISFORM",
"method"=>"post",
"action"=>$_SERVER["PHP_SELF"])));
insert($w, $f = form(array("name"=>"DISPLAY",
"method"=>"post",
"action"=>"displaysubnet.php")));
//Database connection
$link = mysql_pconnect(DBF_HOST, DBF_USER, DBF_PASSWORD) or die("Could not Connect to Database");
mysql_select_db(DBF_NAME) or die(mysql_error());
//This query is for total Paradyne Modems
$query = ("Select sum(modem) from ipaddr ");
$result = mysql_query($query) or die(mysql_error());
$modem = mysql_result($result, 0) or die (mysql_error());
//This query is for the total Westel Modems
$query1 = ("Select sum(wmodem) from ipaddr ");
$result1 = mysql_query($query1) or die(mysql_error());
$wmodem = mysql_result($result1, 0) or die (mysql_error());
//This query is for Vision Net Modems
$query2 = ("Select sum(wmodem) from ipaddr ");
$result2 = mysql_query($query2) or die(mysql_error());
$vmodem = mysql_result($result2, 0) or die (mysql_error());
//This query is for 7ft Crossover
$query3 = ("Select sum(xover) from ipaddr ");
$result3 = mysql_query($query3) or die(mysql_error());
$xover = mysql_result($result3, 0) or die (mysql_error());
//This query is for 50ft Crossover
$query4 = ("Select sum(lxover) from ipaddr ");
$result4 = mysql_query($query4) or die(mysql_error());
$lxover = mysql_result($result4, 0) or die (mysql_error());
//This query is for 7ft Straight
$query5 = ("Select sum(scable) from ipaddr ");
$result5 = mysql_query($query5) or die(mysql_error());
$scable = mysql_result($result5, 0) or die (mysql_error());
//This query is for Filter
$query6 = ("Select sum(filter) from ipaddr ");
$result6 = mysql_query($query6) or die(mysql_error());
$filter = mysql_result($result6, 0) or die (mysql_error());
//This query is for Wall Filters
$query7 = ("Select sum(wfilter) from ipaddr ");
$result7 = mysql_query($query7) or die(mysql_error());
$wfilter = mysql_result($result7, 0) or die (mysql_error());
insert($f,textbrbr(my("Total Number of Paradyne Modems")));
insert($f,output_text(array("name"=>"Modem",
"value"=>"$modem",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of Westel Modems")));
insert($f,output_text(array("name"=>"Westel Modem",
"value"=>"$wmodem",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of VisionNet Modems")));
insert($f,output_text(array("name"=>"Vision Modem",
"value"=>"$vmodem",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of 7ft Crossover Cables")));
insert($f,output_text(array("name"=>"7ft Crossover",
"value"=>"$xover",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of 50ft Crossover Cables")));
insert($f,output_text(array("name"=>"50ft Crossover",
"value"=>"$lxover",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of 7ft Straight Cables")));
insert($f,output_text(array("name"=>"7ft Straight",
"value"=>"$scable",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of Filters")));
insert($f,output_text(array("name"=>"Filter",
"value"=>"$filter",
"size"=>"10",
"maxlength"=>"10")));
insert($f,textbrbr(my("Total Number of Wall Filters")));
insert($f,output_text(array("name"=>"Wall Filter",
"value"=>"$wfilter",
"size"=>"10",
"maxlength"=>"10")));
mysql_close($link);
printhtml($p);
?>
