Code won't display both if statements

Radon3k

For some reason I can't get the two if statements to both show. I've tried using both if statements and while loops and nothing is working. I really need to figure this out and I appreciate any help you can give. Thanks.

<html>
<head>
<title></title>
</head>
<body text="#000000">
To find a record, type a query into the search box:<br>
<form method="post" action="<?php echo("$PHP_SELF")?>">
Family Last Name:<input type="text" name="lname"><br>
<input type="submit" name="subsearch" value="Search"><br><br>
<?php
$db = mysql_connect("localhost", "uname", "password");
if(!$db) {
	echo("Could not connect to the database server.");
}

mysql_select_db("db", $db);
if(!@mysql_select_db("test")) {
	echo("Could not connect to the database.");
}

if($_POST['subsearch'] == "Search") {
	$search = mysql_query("SELECT * FROM family WHERE PLAST_NM LIKE '%$lname%' GROUP BY PLAST_NM");

$num = mysql_num_rows($search);
if($num > 0) {
	while($row = mysql_fetch_array($search)) {
		$famid = $row['fam_id'];
		$firstname = $row['PFIRST_NM'];
		$lastname = $row['PLAST_NM'];
		$addy = $row['ADDRESS'];
		$city = $row['CITY'];
		$state = $row['STATE'];
		$zip = $row['ZIP'];
		$country = $row['COUNTRY'];

		echo("<table cellpadding='0' cellspacing='0' bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td>");
		echo("<b>ID:</b> $famid<br>");
		echo("<b>Name:</b> $lastname, $firstname<br>");
		echo("<b>Address:</b> $addy<br>");
		echo("<b>City:</b> $city<br>");
		echo("<b>State:</b> $state<br>");
		echo("<b>Zip:</b> $zip<br>");
		echo("<b>Country:</b> $country<br>");
		echo("</td></tr>");
		echo("<tr><td align='center'>");
		echo("<a href='sql.php?action=modify&id=$famid'>Modify</a> &nbsp;");
		echo("<a href='sql.php?action=delete&id=$famid'>Delete</a><br>");
		echo("</td></tr>");
	}
}
}

if($_GET['action'] == "modify") {
    $getidf = "SELECT * FROM family WHERE `fam_id` = '$id'" or die(mysql_error());
	$queryf = mysql_query($getidf);
	while($rowf = mysql_fetch_array($queryf)) {
        $famidf = $rowf['fam_id'];
        $fnamef = $rowf['PFIRST_NM'];
        $lnamef = $rowf['PLAST_NM'];
		$addyf = $rowf['ADDRESS'];
		$cityf = $rowf['CITY'];
		$statef = $rowf['STATE'];
		$zipf = $rowf['ZIP'];
		$phonef = $rowf['P_PHONE'];

	echo("<form method='post' action='<?php echo('$PHP_SELF')?>'>");
	echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");
	echo("<tr><td align='center' valign='middle'>");
	echo("<b>Family Table</b>");
	echo("</td></tr>");
	echo("<tr><td>");
	echo("<b>Family ID:</b> $famidf<br>");
	echo("<b>Name:</b> $fnamef $lnamef<br>");
	echo("<b>Address:</b> <input type='text' name='famaddy' value='$addyf'><br>");
	echo("<b>City:</b> <input type='text' name='famcity' value='$cityf'><br>");
	echo("<b>State:</b> <input type='text' name='famstate' value='$statef'><br>");
	echo("<b>Zip:</b> <input type='text' name='famzip' value='$zipf'><br>");
	echo("<b>Phone:</b> <input type='text' name='famphone' value='$phonef'><br>");
	echo("</td></tr></table>");
}
}

if($_GET['action'] == "modify") {
	$getida = "SELECT * FROM accounts WHERE `fam_id` = '$id'" or die(mysql_error());
	$querya = mysql_query($getida);
	while($rowa = mysql_fetch_array($querya)) {
		$famida = $rowa['fam_id'];

	echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");
	echo("<tr><td align='center' valign='middle'>");
	echo("<b>Accounts Table</b>");
	echo("</td></tr>");
	echo("<tr><td>");
	echo("$famida");
}
}
?>

Edit: It's the last two if/while statements at the bottom that are giving me trouble. The first one shows but the second one does not.

stolzyboy

take this

$getida = "SELECT * FROM accounts WHERE `fam_id` = '$id'" or die(mysql_error());
    $querya = mysql_query($getida);
    while($rowa = mysql_fetch_array($querya)) {        $famida = $rowa['fam_id'];               

 echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");       

 echo("<tr><td align='center' valign='middle'>");     

   echo("<b>Accounts Table</b>");       

 echo("</td></tr>");       

 echo("<tr><td>");        

echo("$famida");    }

and put it directly after

echo("</td></tr></table>");    

}

Radon3k

That didn't work. 🙁

jek

Had it got anything to do with the fact that you're using $POST for the first if statement, and $GET in the last two..?

Radon3k

I don't see how considering the if submits the information and the get's retrieve information. To add to that the first table displays but not the second one.

Radon3k

Anybody? This is getting annoying especially when it seems as if nobody else knows...

smeagal

look at your form tag:

<form method="post" action="<?php echo("$PHP_SELF")?>">

and add this query string

<form method="post" action="<?php echo $PHP_SELF."?action=modify"; ?>">

let's hope something pops up..

hth

jek

Also, have you checked if there's a problem with your query in the last if statement... I mean, have you tested it so you're sure it outputs what you want it to...

By entering this into the last if statement on the line before 'while' you should easily see if there's a problem with your query.

$querya_rows = mysql_num_rows($querya);
if (!$querya_rows) {
echo "There are no rows to show";
} else { 
echo "There are rows to show";
}

Radon3k

I added what you said to, jek, and it said "No problem" which is what I told it to echo if the query was OK. Now what?

jek

My last try (then I'm out of ideas):

In your last if statement, the table isn't closed... That could be the reason, depending on which browser you are using.

Adding echo("</td></tr></table>"); to the end of the last if statement would be the answer if this is the problem...

Radon3k

That didn't work either. This is really getting on my nerves. It's been like this for OVER a week and I find it very hard to believe that nobody on this forum can seem to figure it out.

smeagal

look at this:

echo("<form method='post' action='<?php echo('$PHP_SELF')?>'>");

there's another echo statement inside echo. this gives an error. try view the html source and look for any error statements...

fix that and i believe your problem will be solved..

smeagal

opsss.. that gives no error but will print out

maybe this messed up your page layout and the page can't show the output correctly...

hopes this helps

Radon3k

I'm so frustrated right now it's not even funny...I managed to get the second table to show but now I can't get the information from the database to display in the second table itself, here's the updated code:

<html>
<head>
<title></title>
</head>
<body text="#000000">
To find a record, type a query into the search box:<br>
<form method="post" action="<?php echo("$PHP_SELF")?>">
Family Last Name:<input type="text" name="lname"><br>
<input type="submit" name="subsearch" value="Search"><br><br>
<?php
$db = mysql_connect("localhost", "asdf", "asdf");
if(!$db) {
	echo("Could not connect to the database server.");
}

mysql_select_db("test", $db);
if(!@mysql_select_db("test")) {
	echo("Could not connect to the database.");
}

if($_POST['subsearch'] == "Search") {
	$search = mysql_query("SELECT * FROM family WHERE PLAST_NM LIKE '%$lname%' GROUP BY PLAST_NM");

$num = mysql_num_rows($search);
if($num > 0) {
	while($row = mysql_fetch_array($search)) {
		$famid = $row['fam_id'];
		$firstname = $row['PFIRST_NM'];
		$lastname = $row['PLAST_NM'];
		$addy = $row['ADDRESS'];
		$city = $row['CITY'];
		$state = $row['STATE'];
		$zip = $row['ZIP'];
		$country = $row['COUNTRY'];

		echo("<table cellpadding='0' cellspacing='0' bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td>");
		echo("<b>ID:</b> $famid<br>");
		echo("<b>Name:</b> $lastname, $firstname<br>");
		echo("<b>Address:</b> $addy<br>");
		echo("<b>City:</b> $city<br>");
		echo("<b>State:</b> $state<br>");
		echo("<b>Zip:</b> $zip<br>");
		echo("<b>Country:</b> $country<br>");
		echo("</td></tr>");
		echo("<tr><td align='center'>");
		echo("<a href='sql.php?action=modify&id=$famid'>Modify</a> &nbsp;");
		echo("<a href='sql.php?action=delete&id=$famid'>Delete</a><br>");
		echo("</td></tr>");
	}
}
}

if($_GET['action'] == "modify") {
    $getidf = "SELECT * FROM family WHERE `fam_id` = '$id'" or die(mysql_error());
	$queryf = mysql_query($getidf);
	while($rowf = mysql_fetch_array($queryf)) {
        $famidf = $rowf['fam_id'];
        $fnamef = $rowf['PFIRST_NM'];
        $lnamef = $rowf['PLAST_NM'];
		$addyf = $rowf['ADDRESS'];
		$cityf = $rowf['CITY'];
		$statef = $rowf['STATE'];
		$zipf = $rowf['ZIP'];
		$phonef = $rowf['P_PHONE'];
		$famida = $rowf['accounts.fam_id'];
		echo("<form method='post' action='sql.php'>");
		echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td align='center' valign='middle'>");
		echo("<b>Family Table</b>");
		echo("</td></tr>");
		echo("<tr><td>");
		echo("<b>Family ID:</b> $famidf<br>");
		echo("<b>Name:</b> $fnamef $lnamef<br>");
		echo("<b>Address:</b> <input type='text' name='famaddy' value='$addyf'><br>");	
		echo("<b>City:</b> <input type='text' name='famcity' value='$cityf'><br>");
		echo("<b>State:</b> <input type='text' name='famstate' value='$statef'><br>");
		echo("<b>Zip:</b> <input type='text' name='famzip' value='$zipf'><br>");
		echo("<b>Phone:</b> <input type='text' name='famphone' value='$phonef'><br>");
		echo("</td></tr></table>");
		echo("<br><br>");
		echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td align='center' valign='middle'>");
		echo("<b>Accounts Table</b>");
		echo("</td></tr>");
		echo("<tr><td>");
		echo("<b>Family ID:</b> $famida<br>");
	}
}
?>

laserlight

Perhaps try:

<html>
<head>
<title></title>
</head>
<body text="#000000">
To find a record, type a query into the search box:<br>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
Family Last Name:<input type="text" name="lname"><br>
<input type="submit" name="subsearch" value="Search"><br><br>
<?php
if(!($db = @mysql_conect("localhost", "asdf", "asdf"))) {
	exit("Could not connect to the database server.");
}
if(!@mysql_select_db("test", $db)) {
	exit("Could not select database.");
}

if ($_POST['subsearch'] == "Search") {
    $search = mysql_query("SELECT * FROM family WHERE PLAST_NM LIKE '%$lname%' GROUP BY PLAST_NM");

$num = mysql_num_rows($search);
if ($num > 0) {
    while($row = mysql_fetch_array($search)) {
        $famid = $row['fam_id'];
        $firstname = $row['PFIRST_NM'];
        $lastname = $row['PLAST_NM'];
        $addy = $row['ADDRESS'];
        $city = $row['CITY'];
        $state = $row['STATE'];
        $zip = $row['ZIP'];
        $country = $row['COUNTRY'];

        echo '<table cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
        echo '<tr><td>';
        echo '<b>ID:</b> ' . $famid . '<br>';
        echo '<b>Name:</b> ' . $lastname . ',' . $firstname . '<br>';
        echo '<b>Address:</b> ' . $addy . '<br>';
        echo '<b>City:</b> ' . $city . '<br>';
        echo '<b>State:</b> ' . $state . '<br>';
        echo '<b>Zip:</b> ' . $zip . '<br>';
        echo '<b>Country:</b> ' . $country . '<br>';
        echo '</td></tr>';
        echo '<tr><td align="center">';
        echo '<a href="sql.php?action=modify&amp;id=' . $famid . '">Modify</a>&nbsp;&nbsp;';
        echo '<a href="sql.php?action=delete&amp;id=' . $famid . '">Delete</a><br>';
        echo '</td></tr>';
    }
}
}

if ($_GET['action'] == "modify") {
	$id = $_GET['id'];
    $getidf = "SELECT * FROM family WHERE `fam_id` = '$id'";
    $queryf = mysql_query($getidf) OR die(mysql_error());
    if (mysql_num_rows($queryf) > 0) {
	    while ($rowf = mysql_fetch_array($queryf)) {
	        $famidf = $rowf['fam_id'];
	        $fnamef = $rowf['PFIRST_NM'];
	        $lnamef = $rowf['PLAST_NM'];
	        $addyf = $rowf['ADDRESS'];
	        $cityf = $rowf['CITY'];
	        $statef = $rowf['STATE'];
	        $zipf = $rowf['ZIP'];
	        $phonef = $rowf['P_PHONE'];
	        $famida = $rowf['accounts.fam_id'];
	        echo '<form method="post" action="sql.php">';
	        echo '<table border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
	        echo '<tr><td align="center" valign="middle">';
	        echo '<b>Family Table</b>';
	        echo '</td></tr>';
	        echo '<tr><td>';
	        echo '<b>Family ID:</b> ' . $famidf . '<br>';
	        echo '<b>Name:</b> ' . $fnamef . $lnamef . '<br>';
	        echo '<b>Address:</b> <input type="text" name="famaddy" value="' . $addyf . '"><br>';    

	        echo '<b>City:</b> <input type="text" name="famcity" value="' . $cityf . '"><br>';
	        echo '<b>State:</b> <input type="text" name="famstate" value="' . $statef . '"><br>';
	        echo '<b>Zip:</b> <input type="text" name="famzip" value="' . $zipf . '"><br>';
	        echo '<b>Phone:</b> <input type="text" name="famphone" value="' . $phonef . '"><br>';
	        echo '</td></tr></table>';
	        echo '<br><br>';
	        echo '<table border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
	        echo '<tr><td align="center" valign="middle">';
	        echo '<b>Accounts Table</b>';
	        echo '</td></tr>';
	        echo '<tr><td>';
	        echo '<b>Family ID:</b> ' . $famida . '<br>';
	    }
	}
	else {
		echo 'There are no rows in the family table to select based on id #' . $id;
	}
}
?>

The_Chancer

From Laserlights suggestion add try this also:

<html>
<head>
<title></title>
</head>
<body text="#000000">
To find a record, type a query into the search box:<br>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
Family Last Name:<input type="text" name="lname"><br>
<input type="submit" name="subsearch" value="Search"><br><br>
<?php
if(!($db = @mysql_conect("localhost", "asdf", "asdf"))) {
    exit("Could not connect to the database server.");
}
if(!@mysql_select_db("test", $db)) {
    exit("Could not select database.");
}

if ($_POST['subsearch'] == "Search") {
    $search = mysql_query("SELECT * FROM family WHERE PLAST_NM LIKE '%$lname%' GROUP BY PLAST_NM");

$num = mysql_num_rows($search);
if ($num > 0) {
    while($row = mysql_fetch_array($search)) {
        $famid = $row['fam_id'];
        $firstname = $row['PFIRST_NM'];
        $lastname = $row['PLAST_NM'];
        $addy = $row['ADDRESS'];
        $city = $row['CITY'];
        $state = $row['STATE'];
        $zip = $row['ZIP'];
        $country = $row['COUNTRY'];

        echo '<table cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
        echo '<tr><td>';
        echo '<b>ID:</b> ' . $famid . '<br>';
        echo '<b>Name:</b> ' . $lastname . ',' . $firstname . '<br>';
        echo '<b>Address:</b> ' . $addy . '<br>';
        echo '<b>City:</b> ' . $city . '<br>';
        echo '<b>State:</b> ' . $state . '<br>';
        echo '<b>Zip:</b> ' . $zip . '<br>';
        echo '<b>Country:</b> ' . $country . '<br>';
        echo '</td></tr>';
        echo '<tr><td align="center">';
        echo '<a href="sql.php?action=modify&id=' . $famid . '">Modify</a>&nbsp;&nbsp;';
        echo '<a href="sql.php?action=delete&id=' . $famid . '">Delete</a><br>';
        echo '</td></tr>';
    }
}
}

if ($_GET['action'] == "modify") {
    $id = $_GET['id'];
    $getidf = "SELECT * FROM family WHERE `fam_id` = '$id'";
    $queryf = mysql_query($getidf) OR die(mysql_error());
    if (mysql_num_rows($queryf) > 0) {
        while ($rowf = mysql_fetch_array($queryf)) {
            $famidf = $rowf['fam_id'];
            $fnamef = $rowf['PFIRST_NM'];
            $lnamef = $rowf['PLAST_NM'];
            $addyf = $rowf['ADDRESS'];
            $cityf = $rowf['CITY'];
            $statef = $rowf['STATE'];
            $zipf = $rowf['ZIP'];
            $phonef = $rowf['P_PHONE'];
            $famida = $rowf['accounts.fam_id'];
            echo '<form method="post" action="sql.php">';
            echo '<table border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
            echo '<tr><td align="center" valign="middle">';
            echo '<b>Family Table</b>';
            echo '</td></tr>';
            echo '<tr><td>';
            echo '<b>Family ID:</b> ' . $famidf . '<br>';
            echo '<b>Name:</b> ' . $fnamef . $lnamef . '<br>';
            echo '<b>Address:</b> <input type="text" name="famaddy" value="' . $addyf . '"><br>';    

            echo '<b>City:</b> <input type="text" name="famcity" value="' . $cityf . '"><br>';
            echo '<b>State:</b> <input type="text" name="famstate" value="' . $statef . '"><br>';
            echo '<b>Zip:</b> <input type="text" name="famzip" value="' . $zipf . '"><br>';
            echo '<b>Phone:</b> <input type="text" name="famphone" value="' . $phonef . '"><br>';
            echo '</td></tr></table>';
            echo '<br><br>';
            echo '<table border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC" width="400">';
            echo '<tr><td align="center" valign="middle">';
            echo '<b>Accounts Table</b>';
            echo '</td></tr>';
            echo '<tr><td>';
            echo '<b>Family ID:</b> ' . $famida . '<br>';
        }
    }
    else {
        echo 'There are no rows in the family table to select based on id #' . $id;
    }
}
else {echo $_GET['action']." is not what I expected"; }
?>

Radon3k

Well for some reason the search feature stops working with the code you suggested. The problem is now that I get the second table to display I can't get the information from the database to dispaly in the second table.

Radon3k

Nobody knows how to fix this?

Radon3k

Not one person, huh?

smeagal

well Radon3k.. try putting closing tags for your each html table..
if there is nothing wrong with your query, this should work. by the way, what browser are you using? netscape are not so smart handling missing html tags like IE. it won't display the whole page or some part of the page. don't know about other browsers. try it out and your problem might be solved. if not, then we'll try something else...

btw, do you have this thing online so that i can see from my point of view..