No errors but it won't echo

[Radon3k]

<?php
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 = mysql_query("SELECT * FROM family WHERE `fam_id` = '$famid'") or die(mysql_error());
	if($getrow = mysql_fetch_array($getidf)) {
		$fam_id = $getidf['fam_id'];
		$mem_id = $getidf['mem_id'];
		$f_name = $getidf['f_name'];
		$l_name = $getidf['l_name'];

	echo("test");
}
}
?>

I don't get any errors thrown in the last bit but it won't echo the word "test" or anything else I tell it to echo, such as the variables. Can anyone tell me why this is? Thanks. 🙂

[The_Chancer]

Just change this

if($_GET['action'] == "modify") {
    $getidf = mysql_query("SELECT * FROM family WHERE `fam_id` = '$famid'") or die(mysql_error());
    if($getrow = mysql_fetch_array($getidf)) {
        $fam_id = $getidf['fam_id'];
        $mem_id = $getidf['mem_id'];
        $f_name = $getidf['f_name'];
        $l_name = $getidf['l_name'];

    echo("test");
}
}

to this

if($_GET['action'] == "modify") {
    $getidf = mysql_query("SELECT * FROM family WHERE `fam_id` = '$famid'") or die(mysql_error());
    if($getrow = mysql_fetch_array($getidf)) {
        $fam_id = $getidf['fam_id'];
        $mem_id = $getidf['mem_id'];
        $f_name = $getidf['f_name'];
        $l_name = $getidf['l_name'];

    echo("test");
}
else { echo "getrow not there";}
}
elseif ($_GET['action']!="modify") {
echo $action." does not equal modify";
}

and see what gets echoed out... then you will know where your problem lies.

[OhLordy]

do echo($_GET['action']); outside of the if statement and see if the expected value is in there.
good luck
Rob

[The_Chancer]

Posted at the same minute - what are the chances of that happening ??

[Radon3k]

Hi guys,

It echo's out, "getrow not there".

[kevinsequeira]

print the query out

print ($getidf);

see what it is and try running it directly on the database

in other words debug the code, it should solve your problem
reg
kevin

[stolzyboy]

throw this the line after you set it equal to a query to ensure you are getting the correct result from the query

echo $getidf;

[Radon3k]

It echos, "Resource id #2".

On the main page before you hit submit for search it says, "does not equal modify". Which is a problem in itself I suppose. But I'm not sure how it can't equal that.

[stolzyboy]

sorry do this

$guery = "SELECT * FROM family WHERE fam_id = '$famid'") or die(mysql_error());
$getidf = mysql_query($query);
echo $getidf;

instead of this

$getidf = mysql_query("SELECT * FROM family WHERE fam_id = '$famid'") or die(mysql_error());
echo $getidf;

then let us know what it echos

[kevinsequeira]

damn, how did i miss that , this

 $fam_id = $getidf['fam_id'];

    $mem_id = $getidf['mem_id'];

    $f_name = $getidf['f_name'];

    $l_name = $getidf['l_name'];

sould be ...

 $fam_id = $getrow['fam_id'];

    $mem_id = $getrow['mem_id'];

    $f_name = $getrow['f_name'];

    $l_name = $getrow['l_name'];

try this out instead and list any errors that might occur

<?php
if($_GET['action'] == "modify") {
$query = "SELECT * FROM family WHERE fam_id = '".$famid.'";
$result = mysql_query($query);
if(mysql_error(){
print("error is ".mysql_error();
}
if($row = mysql_fetch_array($result)) {

    $fam_id = $row['fam_id'];

    $mem_id = $row['mem_id'];

    $f_name = $row['f_name'];

    $l_name = $row['l_name'];

		echo $fam_id.",".$mem_id.",".$f_name.",".$l_name."<BR>";

}

else { echo "getrow not there";}

}

elseif ($_GET['action']!="modify") {

echo $action." does not equal modify";

}
?>

reg
kevin

[stolzyboy]

duh, LOL, looks like i missed that also

[Radon3k]

<?php
if($_GET['action'] == "modify") {
    $getidf = "SELECT * FROM family WHERE `fam_id` = '$famid'" or die(mysql_error());
	$query = mysql_query($getidf);
	echo("$query");
	if($getrow = mysql_fetch_array($query)) {
        $fam_id = $getrow['fam_id'];
        $mem_id = $getrow['mem_id'];
        $f_name = $getrow['f_name'];
        $l_name = $getrow['l_name'];

	echo("$famid");
}
}
?>

That's what I have now. It echos, "Resource id #2". Oh, and now I don't feel as bad about the array seeing as how two other people didn't catch onto it for a few minutes 😉. Thanks for the help. 🙂

[stolzyboy]

change this

$getidf = "SELECT * FROM family WHERE fam_id = '$famid'" or die(mysql_error());
$query = mysql_query($getidf);
echo("$query");

to this

$getidf = "SELECT * FROM family WHERE fam_id = '$famid'" or die(mysql_error());
echo("$query");
$query = mysql_query($getidf);

notice the echo query is a line up

[Radon3k]

It echo's nothing.

[stolzyboy]

sorry again, i think my brain is broke

change this

echo("$query");

to

echo("$getidf");

[Radon3k]

SELECT * FROM family WHERE fam_id = '' is what it echos.

[kevinsequeira]

well the variable has no value !! can u post the code for the entire page and how are you getting to this page, thorugh a form ???
has famid been selected in the form
reg
kevin

[stolzyboy]

well then you aren't getting your

$famid from where you think you are getting it, try echoing it out up in the while loop to ensure you are getting something there, there is a part where you have

$famid = $row['famid'];

in your while loop, just echo $famid out after that line and see that you are getting something there

[Radon3k]

I know it's getting something in the while loop because the URL when you mouse over it says, "http://www.blah.com/index.php?action=modify&id=2" or whatever the number is. So apparently the variable didn't cary through past the while statement, yet the variables for the links did...

[kevinsequeira]

AAAAH.....
if the url is
http://www.blah.com/index.php?action=modify&id=2
then this should
SELECT * FROM family WHERE fam_id = '$id'"
re
kevin