Code: Select all
<?php
session_start();
if (!isset($HTTP_SESSION_VARS['login'])){
header ('Location: login.php');
exit;
}
elseif (!$_POST["isseen"]) {
//Show search form
include ("includes/config.inc");
include ("includes/searchfosterform.inc");
}
else {
//Do search
include ("includes/config.inc");
$formresult = $_POST["search"];
$selection = $_POST["selection"];
$link = mysql_connect($server, $dbuser, $dbpass)
or die("Could not connect: " . mysql_error());
//print ("Connected successfully<br>");
mysql_select_db($database, $link)
or die("Could not select database: " . mysql_error());
//print ("Database Selected<br>");
$result = mysql_query("SELECT * FROM foster WHERE $selection ='$formresult'");
while ($row = mysql_fetch_array($result)) {
$id = $row["ID"];
$name = $row["Firstname"];
$surname = $row["Lastname"];
$address = $row["Address"];
$city = $row["City"];
$zipcode = $row["Zipcode"];
$state = $row["State"];
$phone = $row["Phone"];
$email = $row["Email"];
$homepage = $row["Homepage"];
$membermonth = $row["Membermonth"];
$memberyear = $row["Memberyear"];
$nextmonth = $row["Nextmonth"];
$nextyear = $row["Nextyear"];
$foster = $row["Foster"];
$fosterselect = $row["Fosterselect"];
$approvedby = $row["Approvedby"];
$approveddate = $row["Approveddate"];
$lastinspected = $row["Lastinspected"];
$transport = $row["Transport"];
$traileroption = $row["Traileroption"];
$transportradius = $row["Transportradius"];
$approvedby2 = $row["Approvedby2"];
$approveddate2 = $row["Approveddate2"];
$lastinspected2 = $row["Lastinspected2"];
$inspector = $row["Inspector"];
$approveinspector = $row["Approveinspector"];
//$notes $row["Notes"];
}
include ("includes/resultfoster.inc");
}
?>this is the nonworking code:
Code: Select all
<?php
session_start();
if (!isset($HTTP_SESSION_VARS['login'])){
header ('Location: login.php');
exit;
}
elseif (!$_POST["isseen"]) {
//Show search form
include ("includes/config.inc");
include ("includes/searchfosterform.inc");
}
else {
//Do search
include ("includes/config.inc");
$formresult = $_POST["search"];
$selection = $_POST["selection"];
$link = mysql_connect($server, $dbuser, $dbpass)
or die("Could not connect: " . mysql_error());
//print ("Connected successfully<br>");
mysql_select_db($database, $link)
or die("Could not select database: " . mysql_error());
//print ("Database Selected<br>");
$result = mysql_query("SELECT * FROM foster WHERE $selection ='$formresult'");
while ($row = mysql_fetch_array($result)) {
$id = $row["ID"];
$name = $row["Firstname"];
$surname = $row["Lastname"];
$address = $row["Address"];
$city = $row["City"];
$zipcode = $row["Zipcode"];
$state = $row["State"];
$phone = $row["Phone"];
$email = $row["Email"];
$homepage = $row["Homepage"];
$membermonth = $row["Membermonth"];
$memberyear = $row["Memberyear"];
$nextmonth = $row["Nextmonth"];
$nextyear = $row["Nextyear"];
$foster = $row["Foster"];
$fosterselect = $row["Fosterselect"];
$approvedby = $row["Approvedby"];
$approveddate = $row["Approveddate"];
$lastinspected = $row["Lastinspected"];
$transport = $row["Transport"];
$traileroption = $row["Traileroption"];
$transportradius = $row["Transportradius"];
$approvedby2 = $row["Approvedby2"];
$approveddate2 = $row["Approveddate2"];
$lastinspected2 = $row["Lastinspected2"];
$inspector = $row["Inspector"];
$approveinspector = $row["Approveinspector"];
$notes $row["Notes"];
}
include ("includes/resultfoster.inc");
}
?>You will see that the only difference is that the notes line have had the // removed, why don't it work? is there a limit ofthe number of rows you can pull out or what is the problem?
please help
Godiwa
